Loading

Google Sheets + Typeform

Collect new Typeform responses as rows on Google Sheets

Forms are great at capturing user information, but exporting their results takes time. Zapier can help you analyze those entries in a spreadsheet automatically with this integration. Once you set it up, it will catch every new entry you receive on a Typeform, saving the results to a new row on Google Sheets so you don't have to do it yourself.

Forms are great at capturing user information, but exporting their results takes time. Zapier can help you analyze those entries in a spreadsheet automatically with this integration. Once you set it up, it will catch every new entry you receive on a Typeform, saving the results to a new row on Google Sheets so you don't have to do it yourself.

  1. When this happens...
    TypeformTypeform
    New Entry

    Triggers when a form is submitted.

    TriggerInstant
  2. automatically do this!
    Google SheetsGoogle Sheets
    Create Spreadsheet Row

    Create a new row in a specific spreadsheet.

    ActionWrite
Try this template
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • FormRequired

    Trigger
    Instant
    Try It
    • Form To DuplicateRequired

    • Choose Workspace To Duplicate This Form In (Leave blank to duplicate in same workspace)

    • Title of Your Duplicate Form (leave blank for same title)

    Action
    Write
    • Owner

      Determines which App Extensions will appear in the dropdown below.

    • App ExtensionRequired

    Action
    Write
    • FormRequired

    • responses submitted since the specified date and time.

      Limit request to responses submitted since the specified date and time. Could be passed as int (timestamp in seconds) or in ISO 8601 format, UTC time, to the second, with T as a delimiter between the date and time

    • responses submitted until the specified date and time.

      Limit request to responses submitted until the specified date and time. Could be passed as int (timestamp in seconds) or in ISO 8601 format, UTC time, to the second, with T as a delimiter between the date and time. NOTE: until must be after since if both parameters are specified

    • search for responses that include the specified string.

    • search for responses that are complete.

    • maximum number of responses to fetch (default: 25, max: 1000)

    Action
    Search
    • title of your formRequired

    • Choose Workspace To Create This Form In, leave it blank for default workspace

    Action
    Write
    • Form To Update Question inRequired

    • Please provide list of choices

    Action
    Write
    • Api Docs Info

      API docs for Typeform are located here https://www.typeform.com/help/data-api/

    • HTTP MethodRequired

    • URLRequired

      Requests can only be made to domains associated by this application.

    • Query String Parameters

      These params will be URL-encoded and appended to the URL when making the request.

    • Headers

      Authentication headers are included automatically

    • Additional Request Headers

      Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.

    • Body

      Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example, {"foo": "bar"} is perfectly valid.

    Action
    Write
    • Drive

      The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.

    • SpreadsheetRequired

    • WorksheetRequired

      You must have column headers

    Trigger
    Scheduled
    Try It
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn more

Related categories

  • Google
  • Spreadsheets

Similar apps

Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
Quip integrationsQuip integrations

Quip

Documents
typeform logo
typeform logo

About Typeform

Typeform helps you ask awesomely online! If you ever need to run a survey, questionnaire, form, contest etc. Typeform will help you achieve it beautifully across all devices, every time, using its next generation platform.
Learn more

Related categories

Similar apps

Wufoo integrationsWufoo integrations

Wufoo

Forms & Surveys
Formstack integrationsFormstack integrations

Formstack

Forms & Surveys
Jotform integrationsJotform integrations

Jotform

Forms & Surveys

Get started for free

You can't add more hours to the day. Zapier is the next best thing.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.