Hi All, I I'm currently trying to export data from an Elasticsearch index into Google Sheets using Google Apps Script, but I'm having difficulty with the integration. Specifically, I'm looking for an example script that:
- Connects to an Elasticsearch endpoint (via basic authentication).
- Queries the Elasticsearch index using filters and aggregations.
- Exports the data from the query results and writes it into a Google Sheet.