Google Sheets Destination

Google Sheets Destination Documentation

google sheets logo

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
  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.