Best answer

How do I merge 2 Typeforms into one Google Sheet

  • 22 October 2021
  • 2 replies
  • 126 views

Hello zapier community

I would like to merge the information from two Typeforms on one google sheets file.

The goal would be to track the client's responses via this sheets file.

Do you have any solutions?

Thanks

icon

Best answer by Troy Tessalone 23 October 2021, 00:15

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Hello Troy,

 

Thank you so much for this information. It helped me a lot. 

 

Best,

Ricardo

Userlevel 7
Badge +14

Hi @R_fnds 

You’d have to use a common unique data point (e.g. email address) to find/update the same row in the GSheet.

 

Zap 1

For Typeform 1

  1. Trigger: Typeform - New Entry
  2. Action: GSheets - Create Spreadsheet Row

 

Zap 2

For Typeform 2

  1. Trigger: Typeform - New Entry
  2. Action: GSheets - Lookup Spreadsheet Row
  3. Action: GSheets - Update Spreadsheet Row (map the Row ID from Step 2)