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.
Follow the next steps to allow MovingLake to connect to your spreadsheet:
- Go to your desired sheet and add the following email as Editor firstname.lastname@example.org.
- 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.