Here are some guidelines to create a Custom Data Source using a Google Sheet:

• Here is an example of Google Sheet properly formatted for an import. Note that:
  • Only one tab can be imported as a source (and the name of this tab should not be modified after your set up your integration)
  • A date column is mandatory (with proper formatting such as 2024-01-01)
  • Several dimensions can be present in your file, and will have to be mapped against spyne dimensions (including Account Name, Account Id, Campaign Name, Campaign Id, Adgroup Name, Adgroup Id, Ad Name, Ad Id)
• In your Google Drive, add the email *[email protected]* as a Viewer for the Google Sheet you want to sync. Make sure it is actually a plain Google Sheet, and not an .xls file viewed as a Google Sheet.
• In Workspace Settings under the Integrations section, click on Spreadsheet Source and paste the URL of the Google Sheet you want to connect

• Select the proper tab (in this example the campaigns tab)

• Match the Google Sheet columns to spyne’s data model

• Click on Connect button

Important notes:

• Google Sheet sources work in “Full refresh” mode: each day, previous values stored in spyne’s databases will be dropped, and values in the Google Sheet will be imported
• Modification in a Google Sheet will not immediately impact data in your dashboard: data is updated and processed once a day, usually early in the morning before office hours
• Sub dimensions such as Device, Gender, Country, Site … are currently not supported for Google Sheet imports
• Campaigns pacing (with dimensions such as Budget, Start Date, End Date) are not yet supported for Google Sheet imports