# Google 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

{% embed url="<https://www.youtube.com/watch?v=t4svYzPb_G8>" %}
How to Add a Google Sheet
{% endembed %}

## 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*](mailto:support@daasity.com) *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.&#x20;

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
;
```

<br>

{% hint style="info" %}
Please Reach out to <support@daasity.com> if you need help!
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.daasity.com/core-concepts/data-integrations/custom-data-inputs/google-sheet.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.