> ## Documentation Index
> Fetch the complete documentation index at: https://docs.definite.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

> Connect Google Sheets and push query results to spreadsheets.

## Connect to Google Sheets

<Steps>
  <Step>
    In the Definite homepage, go to `Settings` <Icon icon="arrow-right" iconType="solid" /> `Integrations` and select Google Sheets.
  </Step>

  <Step>
    Create a nickname for your integration and click `Authorize`.
  </Step>

  <Step>
    Go through the Google auth login flow and click `Allow`.
  </Step>
</Steps>

Your Google Sheets integration is now set up.

## Push Data to Google Sheets

<Steps>
  <Step>
    In your block with the data you want to send, click the More menu icon `( ... )` > `Configure` which should bring up a Configure sidebar on the right hand side like this:

    <Frame>
      <img src="https://mintcdn.com/definite-a33bcb82/SCrSDlr5bkjAKUtj/images/destinations/image-3.png?fit=max&auto=format&n=SCrSDlr5bkjAKUtj&q=85&s=47e678a59c7a829c32638e392d858683" alt="" width="569" height="672" data-path="images/destinations/image-3.png" />
    </Frame>
  </Step>

  <Step>
    Click `Add Automation`. Fill these in under **Schedule**:

    * `Period`: select how frequently you want to push data to the spreadsheet
    * `Action`: select Send to Google Sheets
    * `Integration`: the nickname for the Google Sheets integration you created above
    * `Spreadsheet ID`: can be found in this part of the url of the Google Sheet you would like to send data to:

    <Frame>
      <img src="https://mintcdn.com/definite-a33bcb82/SCrSDlr5bkjAKUtj/images/destinations/image-4.png?fit=max&auto=format&n=SCrSDlr5bkjAKUtj&q=85&s=acb66f6d1fa2c3e48de240d3eefa8978" alt="" width="1482" height="52" data-path="images/destinations/image-4.png" />
    </Frame>

    * `Spreadsheet Name`: name of the sheet/tab within your Google Sheets file

    Once filled in, it should look something like this:

    <Frame>
      <img src="https://mintcdn.com/definite-a33bcb82/SCrSDlr5bkjAKUtj/images/destinations/image-5.png?fit=max&auto=format&n=SCrSDlr5bkjAKUtj&q=85&s=5889a6d839b1327b401b0572db0c2b72" alt="" width="687" height="948" data-path="images/destinations/image-5.png" />
    </Frame>
  </Step>

  <Step>
    Hit `Create`. The results of your block should now be in your target Google Sheet.

    <Frame>
      <img src="https://mintcdn.com/definite-a33bcb82/SCrSDlr5bkjAKUtj/images/destinations/image-6.png?fit=max&auto=format&n=SCrSDlr5bkjAKUtj&q=85&s=759e95340101b79f04b0fadc78a8c5c7" alt="" width="1920" height="1080" data-path="images/destinations/image-6.png" />
    </Frame>

    <Frame>
      <iframe width="100%" height="400" src="https://www.youtube.com/embed/2ALXT4AUcIw" title="Connecting Google Sheets to Definite" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen />
    </Frame>
  </Step>
</Steps>
