Automation scenario using Make.com to transfer responses from a Google Form into a Google Sheet

How To
,
1

Hello everyone,

I’m working on an automation scenario using Make.com to transfer responses from a Google Form into a Google Sheet. Here’s an overview of the setup:

  • Trigger Module: Google Forms - Watch Responses
  • Action Module: Google Sheets - Add a Row

The goal is to transfer responses from a Google Form into a Google Sheet. Each product (e.g., “Classic Burger” or “Marinated Burger”) selected in the form should be added as a separate row in the Google Sheet, along with its quantity.

I need help identifying the necessary modules and their configuration to handle multiple products dynamically.

Thank you for your help!

2

Hi @John_Doe_Agno

image
image979×419 23.7 KB

Using the watch module, you can capture new responses, apply a filter to check if the selected option is “Classic Burger” or “Marinated Burger,” and then add a row accordingly.

Best regards,

Msquare Automation
Platinum Partner of Make
@Msquare_Automation