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 [e-mail] 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 "#"

• Please make sure that both the Metadata Sheet ID and Sheet name are correct.

• Please check any redundant spacing characters.

---

Also please make sure that the column name of any sheet is on 1 same line only.

Step 5: Input your Connection name and Metadata Sheet ID

• After filling out the Connection name (it should be a unique name) and your Metadata Sheet ID, click the Continue button.

---

• Your Google Sheets connection is ready to process and use as a data model.