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

# Google Sheets

Automatically send every form submission to a Google Sheet, so you can track, filter, and analyze your data using a tool you're already familiar with - no manual copy-pasting required.

Once connected, PipedForm will append a new row to your spreadsheet for every submission, including the submission date and time, making it easy to keep a running log of all your form activity.

<Note>
  This is available on the **Paid** plan.
</Note>

## Setting Up Google Sheets Integration

Follow these steps to connect your form to a Google Sheet.

<Steps>
  <Step title="Create a Spreadsheet for Your Form">
    Create a Google Sheets spreadsheet that you'll use to store submissions from this form.
  </Step>

  <Step title="Connect Your Google Account">
    Go to **Integrations** page, **Add Integration** > **Google Sheets**. You'll be redirected to Google to authorize PipedForm to access your spreadsheets.
  </Step>

  <Step title="Select Your Spreadsheet and Sheet">
    Once connected, open your form's Integration settings and select the Google Sheets integration you just added.

    A modal will appear, Enter the **spreadsheet ID**, or click **+ Create** to create a new spreadsheet, then enter the **Spreadsheet Name** (we recommend using a name that matches your spreadsheet's title for easier identification).

    The sheet name you enter must match the sheet (tab) name in your spreadsheet exactly, including capitalization.

    <Frame>
      <img src="https://mintcdn.com/pipedform/u9qEVjG3kVY8xotp/images/add-google-sheet-new.png?fit=max&auto=format&n=u9qEVjG3kVY8xotp&q=85&s=f7a69cb7d35887b2c8ce7f39f1604dd7" alt="Add Google Sheet New" width="528" height="389" data-path="images/add-google-sheet-new.png" />
    </Frame>
  </Step>
</Steps>

## Data Sent to Google Sheets

For every submission, PipedForm appends a new row containing:

* *All submitted form field data*
* `submittedAt` - the date and time the submission was received

<Warning>
  **Notes:**

  * Make sure the sheet name entered in PipedForm matches the actual sheet (tab) name in your spreadsheet exactly - mismatched names will prevent submissions from being recorded.
  * You can connect multiple forms to different sheets within the same spreadsheet, or use separate spreadsheets entirely.
  * If you revoke PipedForm's access from your Google account, this integration will stop working until reconnected.
</Warning>