One typeform feeding to multiple Google Sheets?

Hello @Jonathan Twombly , welcome to the community! 

Howdy, @Liz 

Happy Friday, everyone!

So this is something that can, indeed, be easily achieved with Integromat. 

Situation: Let’s say I have a typeform in which I ask about people’s dessert preference (cake vs ice cream). I want to store everyone who wants to have some cake in one spreadsheet and everyone who asked for ice cream in another sheet. 

Sooo let’s head over to Integromat’s scenario builder and:

• select the ‘Watch Responses’ Typeform module, create a connection between Typeform and Integromat and select the form you want to monitor

• in order to create two pathways in which to send your data (i.e. cake vs ice cream responses), you’re gonna need to add Integromat’s in-built tool called a ‘router’ to your scenario

• add two ‘Add a Row’ Google Sheets modules, create a connection between Google Sheets and Integromat, select the spreadsheets you want to update with the incoming responses and map the values you want to move from Typeform to your sheet from the Typeform module

• finally, in order to send info about cake and ice cream to the correct sheet, we need to set up some conditional logic using filters: click the dotted line between the router and the GS module, label the filters and set up the logic so that 

if the answer to Cake/Ice Cream equals Cake → send data to Google Sheet 1

if the answer to Cake/Ice Cream equals Ice Cream → send data to Google Sheet 2

Finally, you can hit ‘run once’ and send some testing data to your form to see if all works flawlessly. 

Weeeell and this is what the full scenario would look like

If you’re curious to see what other options there are when working with Typeform and Google Sheets on Integromat, you can check out the currently available features of the integrations here:

Typeform on Integromat

Google Sheets on Integromat

To start exploring the automation fun, you can simply sign up for a free Integromat account and get the party started