In this article we will show how to automatically connect typeform to Google Sheets in just a few clicks. Simply follow the steps below:
Using the link below, go to Typeform’s Google Sheets integration page.
https://www.typeform.com/connect/google-sheets/send-responses-to-google-sheets/
In our example we will click the Sign in with Google button and choose our google account.
Alternatively you can select the Sign up with email option below.
Choose your Google account and select accept.
A popup will prompt you to Create a new Typeform or Choose an existing Typeform that will be connected to Google Sheets.
If Creating a New Typeform:
A prompt box will let you create a new Typeform. Two boxes will allow you to customize your Typeform.
Assign a name in the text box, in our example we have called it ‘MyTypeform’
In the second box, select the style of Typeform you want to generate from the assortment of presets in the dropdown, including an ‘Other’ option for customization.
With your settings selected, click Continue and your new Typeform will be generated.
If Choosing an Existing Typeform:
Click on the dropdown menu that appears and select the Typeform you want to connect to google sheets.
At the top of Typefrom you created / chose, click the option to Connect.
Select the Google Sheets option to connect your Typeforms data by clicking Connect
A Prompt option will ask you to either ‘Create new sheet’ or ‘Use existing’.
At the bottom of the page you can name your spreadsheet, in our example we have called our sheet ‘Test Sheet one’. With the name assigned, click Create Sheet
The new Google Sheets spreadsheet will automatically load in a new screen.
When data is entered into your Typeform it will appear in this sheet automatically. This option can be disabled in Typeform settings at any time.
We hope this article has helped you and given you a better understanding of how to connect Typeform to Google Sheets. You might also like our articles on how to connect Salesforce to Google sheets and how to send slack messages to Google Sheets.
To optimize your workflow, we recommend reading our guide on how to set up email validation in Google Sheets.
