Hey everyone! I’m new to automation and trying to set up something for my work. I’ve got this Google Form that we send to customers after they pay. What I’m hoping to do is make it so that when someone submits the form, it starts an n8n workflow.
I’ve seen how to do this with Google Sheets, but I’m stumped on how to make it work with Forms. Does anyone have any ideas?
Here’s what I’m aiming for:
Customer fills out the Google Form
n8n workflow kicks off
Workflow sends an email with the customer’s name and does some sentiment analysis
If the sentiment is good, it sends another email with a link to leave a Google review
I’d really appreciate any help or tips! Thanks in advance!
I’ve actually tackled this exact challenge recently. Here’s what worked for me:
Instead of directly connecting Google Forms to n8n, I used Google Sheets as a bridge. Set up your Google Form to automatically populate a Google Sheet with responses. Then, use n8n’s Google Sheets trigger node to monitor that sheet for new entries.
This approach is straightforward and doesn’t require additional services or coding. In your n8n workflow, you can easily extract the form data from the sheet, perform your sentiment analysis, and handle the email logic.
One tip: make sure to add a ‘processed’ column in your sheet and mark entries as processed in your workflow to avoid duplicate triggers.
This method has been rock-solid for me, handling hundreds of form submissions without a hitch. Give it a try and see if it suits your needs!
While Google Apps Script is a viable option, another approach worth considering is utilizing Zapier as an intermediary. Zapier can monitor Google Forms submissions and trigger your n8n workflow accordingly. Set up a Zap that watches for new form responses, then use Zapier’s Webhook action to send the data to your n8n webhook node. This method doesn’t require coding and offers a straightforward setup process. It’s particularly useful if you’re dealing with multiple forms or anticipate scaling your automation in the future. Just ensure you’re mindful of Zapier’s task limits based on your plan.
hey liam! i’ve done smthing similar. try using google apps script to trigger a webhook when the form’s submitted. then set up an n8n workflow that starts with a webhook node. that should do the trick! lmk if u need more help
