How to use the Google Sheets Destination.

This destination syncs your data to your Google Sheet. For each entity / endpoint in the source data, a new worksheet (tab) will be created in your selected spreadsheet. Do note that for Google Sheets we currently only expand first-level JSONs. Any nested array or object received within the JSON will be stored as a string in your cell.

Connector guide.

Follow the next steps to allow MovingLake to connect to your spreadsheet:

1. Go to your desired sheet and add the following email as Editor movinglake-etl-service@movinglake.iam.gserviceaccount.com.
2. Go back to your MovingLake account and create the credentials for the GoogleSheet destination. Use the full URL of your spreadsheet to create the connector.