Google Sheets

CREATE DESTINATION

• Create a Google Sheets Connection
• Select Connection 
• Select the Insert Mode (read more below)
• You are now ready to start with Google Sheets.
• Optionally you can also define an output folder and sheet names per datastream (for details see section below).

Please note:

• By default, only the most recent extract will interact with the destination.
• By default, the data will always be inserted into Sheet1 (gid=0). If more sheets exist, they will not be affected.
• It is currently not possible to modify existing sheets.

IMPORT OPTIONS (MODES)

• TRUNCATE + LOCAL DATA RETENTION - DAY + BUNDLE STREAM: A bundle stream collects daily extracts into one extract and this extract overwrites the content of the entire sheet every time a fetch is executed (recommended option, needs to be used with Local Data Retention +Day & Bundle Stream)
  
  
• APPEND: each extract is added to the existing sheet (advanced, should only be used for certain append-only types of data).
• TRUNCATE: each time import happens, the entire content of the sheet is deleted and replaced by the most recent extract. 

SCHEMA MAPPING

• By default, you are prompted to use Schema Mapping. You can use the defaults or create your own in the Data Schema.
• If no schema mapping is needed, this option can be deselected as well.

SHEET NAMES

Note: Each Datastream will automatically generate a separate sheet in the destination. The default name of the output file is datastreamtype_datastream-id e.g. adwords_83. A hyperlink to the sheet will appear as well next to the name with the first 8 characters of the sheet ID.

• Go to Manage Organizations and select the Destination for the required Organization
• To configure a custom sheet name of a datastream, select the datastream in the left column and put a value in the right column
• Allowed characters for Sheet Name are a-zA-Z0-9  and _
• You can use the placeholders in the right column to configure dynamic sheet names
  • {id} - Datastream ID
  • {app_label} - Datastream Type Short Name
  • {name} - Actual Extract's name
  • %Y - Year (YYYY)
  • %m - Month (MM)
  • %d - Day (DD)