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

# Google Sheets

You can view an how to set up and use the Google Sheet destination in our video guide below:

<Frame>
  <iframe className="w-full aspect-video" src="https://player.mux.com/buPPrs15eStcm92u00fGDWf2p1BcJvojTM01L6Iy2Yz6s?metadata-video-title=How+to+use+the+Google+Sheet+destination&video-title=How+to+use+the+Google+Sheet+destination&accent-color=%232b8761&autoplay=1&muted=1" allow="accelerometer; gyroscope; encrypted-media; autoplay; picture-in-picture;" allowfullscreen="true" />
</Frame>

### Setup

You need to complete two steps before you can start sending data to your Google Sheets.

<Steps>
  <Step title="Authenticate">
    The first step is to authenticate with Google. You can do this by clicking the "Authenticate with Google" button.
    Once you have authenticated, you will be redirected back to Less.
  </Step>

  <Step title="Spreadsheets">
    On the Spreadsheets tab, click the "Open Google File Picker" button. We unfortunately have to use Google's own methodology for choosing which spreadsheets to send data to.

    You can select multiple spreadsheets as long as your in the same directory/folder.
  </Step>

  <Step title="Send data">
    Navigate to the Canvas and input a Destination tool whereever you'd like to send data to your Google Sheets. Choose that Google Sheet destination, choose the relevant spreadsheet and input the sheet name and range you'd like to send data to.
  </Step>
</Steps>
