How do I build a workflow that collects form responses and stores them in Google Sheets?

[Rileywd]

I’m trying to set up an automation where users fill out a form (Typeform or Google Forms), and their responses automatically get saved into a Google Sheet. I’ve connected my form tool to n8n using a webhook trigger, but I’m struggling with mapping the incoming fields properly to columns in Google Sheets. The issue is that sometimes the form submissions don’t have all the fields filled out, and then the Google Sheet row shifts incorrectly. How can I make sure each new response always gets added to the correct column, even if some fields are empty?

[fahmiiireza]

hi there, if you are using google form and wants to connect it to google sheet, you actually dont need n8n for it, because gform and gsheet already have a built in connection for that

go to your google form, - go to the answer section - there will be a button to “link to spreadsheet” - click that

it will automatically built a google sheet based on your google form, and for every form filled, it will automatically be tadded in google sheet

and then if you need more things to automate after tht, then you can use n8n for it, or lets say you need more customization, then yes we can use n8n for it

hope it helps! if this answer your question, please give it a like and mark it as solution as it would greatly help me

[Rileywd]

I love your response, it is easy to understand

[Marie_Martens]

Tools like Google Forms or Tally offer this functionality natively, might be an easier fix.