Google Sheet

Our Enterprise Merchants can add Data to Daasity by using a custom G-Sheet

Our Google Sheet integration extracts Data from your Google Sheet and Loads it into your Database. You can either combine it with other Data or expose it directly in Looker.

Follow along with us in this short video to setup your Google Sheet integration

How to Add a Google Sheet

Data Types

• String - this means text or anything you want stored as text

• Number - this is a whole number (integer) and cannot have any decimals

• Decimal - for any values with a decimal

• Currency - if you have value with a currency symbol choose this so we can remove the symbol and store the value as a decimal

• Boolean - either Yes/No or True/False

• Date - if you want to store the value as a date (if it has a time it gets set to midnight)

• Datetime - if you want to store both the time and the date

• Percentage - removes the percent and stores as a decimal

Working With Google Sheets In Daasity

Once your Google Sheet integration is complete, a table will be generated in Snowflake.

(Presuming you used Daasity's database structure to implement Looker)

There are two ways that Data from a Google Sheet can be used in Looker:

1. Have the data transformed and combined with other data through Daasity ELT process. Contact Daasity Support if you need this.

2. Access the table directly through Looker. You may use Looker to run analysis on the table, or join the table to other tables in your Looker instance.

To access a new table that you've created via a Google sheet, first, you must give Looker access to the new table. To do this, run the below script:

-- GRANT PRIVILEGES TO THE LOOKER USER SO THEY CAN ACESS DATA
GRANT ALL ON SCHEMA
  calendar,
  drp,
  drp_staging,
  ga,
  shopify,
  ugd,
  uos,
  uos_staging
TO yourbrand_looker
;GRANT ALL ON ALL TABLES IN SCHEMA
  calendar,
  drp,
  drp_staging,
  ga,
  shopify,
  ugd,
  uos,
  uos_staging
TO yourbrand_looker
;

Please Reach out to [email protected] if you need help!