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

# How to create a Google Sheets form

> Sync responses from your Fillout form to a Google Sheet in under 30 seconds.

export const SupportBanner = () => {
  const titleId = React.useId();
  return <div className="support-banner" role="region" aria-labelledby={titleId}>
      <span className="support-banner__ring support-banner__ring--outer" aria-hidden="true" />
      <span className="support-banner__ring support-banner__ring--middle" aria-hidden="true" />
      <span className="support-banner__ring support-banner__ring--inner" aria-hidden="true" />
      <span className="support-banner__ring support-banner__ring--center" aria-hidden="true" />

      <div className="support-banner__content">
        <div className="support-banner__title" id={titleId} role="heading" aria-level="2">Still have questions?</div>

        <div className="support-banner__copy">
          <span className="support-banner__line">Our team is happy to help. Start a live chat using the</span>
          <span className="support-banner__line">
            chat bubble <span className="support-banner__chat-icon" aria-hidden="true" /> in the bottom right, or email us at
          </span>
          <span className="support-banner__line">
            <a href="mailto:support@fillout.com">support{'@'}fillout.com</a>
          </span>
        </div>

        <a className="support-banner__cta" href="mailto:support@fillout.com">Contact us</a>
      </div>
    </div>;
};

## What is Google Sheets?

[**Google Sheets**](https://www.google.com/sheets/about/) offers users a collaborative platform to create, edit, and store spreadsheets online. It provides a wide range of features for data analysis, visualization, and sharing, making it a versatile tool for businesses, educators, and individuals.

## Video Tutorial

<iframe class="notion-asset-object-fit" src="https://www.youtube.com/embed/lD4h82s0LeE?feature=shared" title="iframe video" frameborder="0" allowFullScreen loading="lazy" scrolling="auto" width="100%" height="420" />

## How it works

<Steps>
  <Step title="Start with a form synced to Google Sheets">
    On your [**Fillout**](https://build.fillout.com/home) dashboard, [**create a form**](https://www.fillout.com/help/make-a-form). Choose to `Connect` to Google Sheets.

    <img src="https://mintcdn.com/fillout-005a867b/yefRDTRdDy202Hph/images/connect-to-google-sheet.png?fit=max&auto=format&n=yefRDTRdDy202Hph&q=85&s=5783fe4489389397a56e440f5e9e5456" alt="Screenshot of the Google Sheets form creation page" width="1929" height="1047" data-path="images/connect-to-google-sheet.png" />

    Choose your theme (don’t worry, you can always change this later). `Sign in with Google` to connect your account.

    If you already have an existing form, simply click `Integrate` in the top menu and look for `Google Sheets`. Currently, you can sync data to newly created sheets. Existing sheets aren't supported yet.
  </Step>

  <Step title="View the spreadsheet">
    A new sheet will automatically be created that will receive form responses. Click `this sheet` to open the sheet linked to your form.

    <img src="https://mintcdn.com/fillout-005a867b/R7rMGlxIdHBwDsJR/images/Screenshot2025-02-14at2.35.10PM.png?fit=max&auto=format&n=R7rMGlxIdHBwDsJR&q=85&s=3c1b9375e6642f6d9287051902495b44" alt="Screenshot of the Google Sheets form creation page" width="2150" height="755" data-path="images/Screenshot2025-02-14at2.35.10PM.png" />

    <Warning>
      If you disconnect and later reconnect Google Sheets, new entries will go to a completely new sheet, not the original one. Currently, it doesn't support connecting to existing sheets. 
    </Warning>

    **If you connected a blank Fillout form**

    The connected sheet will only have submission Id and submission time columns. 

    **If you connected an existing Fillout form**

    Every question or field added prior to the connection will automatically become a column in your sheet.

    **To add new form fields as sheet columns**

    Submit your form once with the new fields filled in. 

    <img src="https://mintcdn.com/fillout-005a867b/Bc-CfW1Edpr3p-LV/images/sheetstodo.png?fit=max&auto=format&n=Bc-CfW1Edpr3p-LV&q=85&s=9b66a5dca28db3cc81504e94b5473951" alt="Screenshot of the Google Sheets form creation page" width="1442" height="552" data-path="images/sheetstodo.png" />

    <Check>
      Fillout has many powerful features like [**branching**](/help/page-logic) and [conditional hide/appear logic](/help/conditional-hiding). No matter how complex your needs are, there’s a way to build it in Fillout.
    </Check>
  </Step>
</Steps>

## Working with different field/question types in Fillout

**Dates and times**

* Note that all date timestamps that are sent to your Google Sheet (using the `Date time picker` field in Fillout) are written in UTC.
* To display times in a local timezone, you can add an extra formula column to do so.

**Address field**

* By default, each part of the address field is added to separate columns in your Google Sheet. This makes it easy to filter responses by city or state, or simply hide the columns you don’t need.

## Specify a condition

You can run your integration only when a specific condition is met. Check out this [guide](/help/conditional-integration).

## Other spreadsheet integrations

<CardGroup cols={3}>
  <Card title="Sync form responses to Microsoft Excel" color="#FFC738" icon="file-excel" iconType="regular" href="/help/microsoft-excel">
    Add responses to Excel with a form.
  </Card>

  <Card title="Create an Airtable Form" color="#FFC738" icon="table-layout" iconType="regular" href="/help/airtable">
    Use a form to create or update Airtable bases.
  </Card>

  <Card title="Create a SmartSuite form" color="#FFC738" icon="table-list" iconType="regular" href="/help/smartsuite">
    Add responses to a SmartSuite solution.
  </Card>
</CardGroup>

<SupportBanner />
