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

# Google Sheets Integration

> Connect Google Sheets to FormHug and automatically send new form submissions to a spreadsheet

The **Google Sheets integration** sends new FormHug submissions to a connected spreadsheet. Use it when you want a live spreadsheet for reporting, sharing, filtering, or downstream workflows.

You can create a new Google Sheet from FormHug or connect an existing spreadsheet in your Google account.

If you want people to search spreadsheet rows without exposing the sheet itself, pair this with <a href="https://formhug.ai/public-query" target="_blank">Public Query</a> or read <a href="https://formhug.ai/blog/build-lookup-page-from-excel" target="_blank">how to build a lookup page from Excel</a>.

<iframe width="100%" height="400" src="https://www.youtube.com/embed/nGSC0Y1ar3U" title="Google Sheets Integration" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen />

## When to Use Google Sheets

Google Sheets is useful when your team already works from spreadsheets, or when form data needs to be shared outside FormHug.

* Share submissions with teammates who do not need dashboard access
* Build lightweight reports, charts, and pivot tables
* Review event registrations, applications, or survey responses in a familiar table
* Use spreadsheet formulas or Google Workspace automations after submissions arrive

## Before You Start

Make sure you have:

* A FormHug form that is ready to collect submissions
* A Google account you can authorize
* Permission to create or edit the target Google Sheet

<Note>
  The Google Sheets integration sends new submissions after the connection is created. Existing submissions may need to be exported separately if you want historical data in the same sheet.
</Note>

## Connect Google Sheets

Open the form you want to connect, then go to **Settings → Integrations**.

<img src="https://mintcdn.com/formhug-8bc4ebd1/iALiyLWJFdgRUAXP/images/integrations/form-settings-integrations-page.png?fit=max&auto=format&n=iALiyLWJFdgRUAXP&q=85&s=cc8d84753b1d9c13cc507368f90038db" alt="FormHug form settings page showing the Integrations section" width="2930" height="1728" data-path="images/integrations/form-settings-integrations-page.png" />

<Steps>
  <Step title="Open Google Sheets">
    In **Integrations**, choose **Google Sheets**.

    <img src="https://mintcdn.com/formhug-8bc4ebd1/iALiyLWJFdgRUAXP/images/integrations/google-sheets/google-sheets-page-account-1.png?fit=max&auto=format&n=iALiyLWJFdgRUAXP&q=85&s=c6d1a0e053b99fe025859ff93fb26345" alt="Google Sheets integration page showing account connection options" width="2914" height="1720" data-path="images/integrations/google-sheets/google-sheets-page-account-1.png" />
  </Step>

  <Step title="Connect Your Google Account">
    Click **Connect Google Account**, then sign in and allow FormHug to create and update Google Sheets for your account.

    <img src="https://mintcdn.com/formhug-8bc4ebd1/iALiyLWJFdgRUAXP/images/integrations/google-sheets/google-sheets-bind-account-2.png?fit=max&auto=format&n=iALiyLWJFdgRUAXP&q=85&s=3b0648d62eac11b9617ddee8d9b8e751" alt="Google Sheets integration dialog for connecting a Google account" width="1110" height="940" data-path="images/integrations/google-sheets/google-sheets-bind-account-2.png" />
  </Step>

  <Step title="Choose How to Connect">
    Select whether to create a new spreadsheet or use an existing spreadsheet.
  </Step>
</Steps>

## Create a New Google Sheet

Choose **Create new spreadsheet** when you want FormHug to generate a spreadsheet for this form.

<Steps>
  <Step title="Name the Spreadsheet">
    Enter a spreadsheet name. FormHug uses your form fields as columns so incoming submissions stay structured.

    <img src="https://mintcdn.com/formhug-8bc4ebd1/iALiyLWJFdgRUAXP/images/integrations/google-sheets/google-sheets-create-new-sheet-3.png?fit=max&auto=format&n=iALiyLWJFdgRUAXP&q=85&s=49ba987cd400ccdb4e970456afda4f24" alt="Google Sheets setup screen for creating a new spreadsheet from FormHug" width="1120" height="1216" data-path="images/integrations/google-sheets/google-sheets-create-new-sheet-3.png" />
  </Step>

  <Step title="Review the Connection">
    Confirm the Google account, spreadsheet name, and form you are connecting.

    <img src="https://mintcdn.com/formhug-8bc4ebd1/iALiyLWJFdgRUAXP/images/integrations/google-sheets/google-sheets-confirm-review-5.png?fit=max&auto=format&n=iALiyLWJFdgRUAXP&q=85&s=cda084b28a9f2907e7c37fdf95304eab" alt="Google Sheets setup review screen showing the account and spreadsheet connection details" width="1110" height="1046" data-path="images/integrations/google-sheets/google-sheets-confirm-review-5.png" />
  </Step>

  <Step title="Create the Connection">
    Click **Confirm** to create the spreadsheet connection. New submissions will appear in the connected sheet.
  </Step>
</Steps>

## Use an Existing Google Sheet

Choose **Use existing spreadsheet** when your team already has a spreadsheet prepared.

<Steps>
  <Step title="Select the Spreadsheet">
    Pick a spreadsheet from your Google account. Choose a sheet that you can edit.

    <img src="https://mintcdn.com/formhug-8bc4ebd1/iALiyLWJFdgRUAXP/images/integrations/google-sheets/google-sheets-use-existing-sheets-4.png?fit=max&auto=format&n=iALiyLWJFdgRUAXP&q=85&s=c3434c2ba22dc2a2ffd54c00974ad1cb" alt="Google Sheets setup screen for selecting an existing spreadsheet" width="1118" height="1396" data-path="images/integrations/google-sheets/google-sheets-use-existing-sheets-4.png" />
  </Step>

  <Step title="Review the Connection">
    Check the selected account and spreadsheet before saving.
  </Step>

  <Step title="Save the Connection">
    Click **Confirm**. FormHug starts sending new submissions to the selected spreadsheet.
  </Step>
</Steps>

## Manage Connections

After setup, the Google Sheets integration page shows your active connections. Use this list to check which spreadsheet is connected to the form.

<img src="https://mintcdn.com/formhug-8bc4ebd1/iALiyLWJFdgRUAXP/images/integrations/google-sheets/google-sheets-connections-6.png?fit=max&auto=format&n=iALiyLWJFdgRUAXP&q=85&s=2ec7050b1f19a1e0aca1d5a4be0cec86" alt="Google Sheets integration page showing connected spreadsheet records" width="1874" height="384" data-path="images/integrations/google-sheets/google-sheets-connections-6.png" />

If you no longer want to send submissions to a spreadsheet, remove the connection from this page.

## Check Synced Submissions

Submit a test entry after creating the connection. Then open the connected Google Sheet and check that the new row appears.

Each row represents one FormHug submission. Form fields become spreadsheet columns, which makes the data easy to filter, sort, and share.

<img src="https://mintcdn.com/formhug-8bc4ebd1/iALiyLWJFdgRUAXP/images/integrations/google-sheets/google-sheets-check-submissions-7.png?fit=max&auto=format&n=iALiyLWJFdgRUAXP&q=85&s=e5eae1218441426b027474b05c29919d" alt="Connected Google Sheet showing synced submission data in rows and columns" width="1970" height="706" data-path="images/integrations/google-sheets/google-sheets-check-submissions-7.png" />

## Limitations

* The integration syncs new submissions after the connection is created.
* Changes made inside Google Sheets do not update the original FormHug submission.
* If you remove or rename form fields, review your connected sheet to make sure the columns still match your workflow.
* Google account access is managed by Google. If authorization expires, reconnect the account from the integration page.

## Related

<CardGroup cols={2}>
  <Card title="Form Submissions" icon="inbox" href="/docs/features/data/submissions">
    View, filter, and export submissions in the FormHug dashboard
  </Card>

  <Card title="Reports" icon="chart-line" href="/docs/features/data/reports">
    Analyze form results with built-in charts and summaries
  </Card>

  <Card title="Share Forms" icon="link" href="/docs/features/sharing/share-link">
    Share a published form with submitters
  </Card>

  <Card title="Google Email Notifications" icon="envelope" href="/docs/guides/use-cases/gmail-email-notifications">
    Send confirmation emails and reminders from a connected Gmail account
  </Card>

  <Card title="Notion" icon="book-open" href="/docs/integrations/notion">
    Create Notion database pages from form submissions
  </Card>

  <Card title="Slack" icon="slack" href="/docs/integrations/slack">
    Post submission alerts to a channel or direct message
  </Card>

  <Card title="Zapier" icon="bolt" href="/docs/integrations/zapier">
    Automate workflows across CRM, email, and productivity apps
  </Card>

  <Card title="Build a Lookup Page from Excel" icon="file-excel" href="https://formhug.ai/blog/build-lookup-page-from-excel" target="_blank">
    Turn spreadsheet-style data into a self-service lookup page
  </Card>

  <Card title="Public Query" icon="magnifying-glass" href="https://formhug.ai/public-query" target="_blank">
    Let visitors search their own record without opening your spreadsheet
  </Card>
</CardGroup>
