■Overview
By using the workflow "When there is a response in Google Forms, retrieve data from Google Sheets and send it out in bulk via Gmail," you can automate the mass emailing based on form response information.
This eliminates the need for manual sending tasks, reducing the workload.
■Recommended for
■Benefits of using this template
This automated flow, which allows you to retrieve data from Google Sheets based on Google Forms responses and send it out in bulk via Gmail, has several advantages.
Firstly, since there is no need to create or send emails individually, you can proceed with tasks quickly.
This allows you to allocate more time to the tasks you truly want to focus on.
Additionally, by utilizing data on Google Sheets, you can eliminate the repetitive copying or transcription tasks for the person in charge, achieving efficient information sharing.
You can send notifications, announcements, follow-ups, etc., without omissions, reducing the risk of information transmission errors.



When an email matching specific keywords is received
When an email with a specific label is received
When an email with a specific label is received (Specify Label ID)
When a form response is submitted
When a row is added
When a row is updated
Search emails
Move Message to Trash
Add Label to Specific Message
Remove Label from Specific Message
Retrieve Specific Message
Retrieve list of responses
Retrieve a specific response
Retrieve list of responses (specify time range)
Get Form Questions
Update Form Title and Description
Update Question Titles and Descriptions
Create a new form
Update form visibility settings
Add a short/paragraph question (title and description)
Add a choice question (radio, checkbox, or dropdown)
Add a grid question (multiple-choice grid / checkbox grid)
Add a question title and description (Date/Time)
Add a question title and description (Linear scale)
When an email matching specific keywords is received
When an email with a specific label is received
When an email with a specific label is received (Specify Label ID)
Search emails
Move Message to Trash
Add Label to Specific Message
Remove Label from Specific Message
Retrieve Specific Message
When a form response is submitted
Retrieve list of responses
Retrieve a specific response
Retrieve list of responses (specify time range)
Get Form Questions
Update Form Title and Description
Update Question Titles and Descriptions
Create a new form
Update form visibility settings
Add a short/paragraph question (title and description)
Add a choice question (radio, checkbox, or dropdown)
Add a grid question (multiple-choice grid / checkbox grid)
Add a question title and description (Date/Time)
Add a question title and description (Linear scale)
Add a question title and description (Image + text)
Add a question title and description (Image + choice)
Add a question title and description (Choices with images)
When a row is added
When a row is updated
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Write values to a range
Insert image into a cell
Sort by a specific column
Hide a sheet
Add a note to the specified cells
Insert columns
Delete columns
Write values to multiple columns