Google Sheets

By integrating your sheets in Google Sheets with Trino to create a Data model in Endash, you can efficiently update your data, ensuring that it remains current and synchronized. This connection provides a smooth and user-friendly experience, making data management more efficient and accessible with only just a few steps to set up.

Step 1: Whitelist Endash IP addresses

If you maintain an IP whitelist for your database, you’ll need to whitelist these below Endash IP addresses so that your data can be accessed properly:

175.45.203.148

Step 2: Grant permission

Please grant our service account endash@cigro-cloud.iam.gserviceaccount.com permission to access this sheet and any other sheets defined in the metadata.

Step 3: Check your Metadata Sheet ID

The Metadata Sheet ID is the number of characters in your URL, after /d/ and before /edit.
For example: If your Google Sheets URL is https://docs.google.com/spreadsheets/d/abcedefghijklnmopqrstuvw5DV7uS9b1mI/edit?gid=0#gid=0 -> then the Metadata Sheet ID is abcedefghijklnmopqrstuvw5DV7uS9b1ml

Step 4: Set up a Reading sheet so Trino can read the data in your sheet(s)

Create a Reading sheet, and name it as you want.
Create a column for the Table name(s) and the SheetID name(s), you can name them as you want.

The Table name shall be the data model name, you can name them as you want.

You should not use any special character, aside from the underline "_".

For the SheetID name(s), follow this format: Metadata_Sheet_ID#sheet_name
For example: abcedefghijklnmopqrstuvw5DV7uS9b1ml#Sheet 1 with
- abcedefghijklnmopqrstuvw5DV7uS9b1ml is the Metadata Sheet ID
- Sheet 1 name is the Sheet name
- Separate the Metadata Sheet ID and Sheet name with the "#"