■Overview
By using the workflow "Update Google Sheets data when there is a response in Google Forms," you can automatically reflect the form input into the spreadsheet.
This saves the trouble of manual transcription, leading to increased work efficiency.
■Recommended for
■Benefits of using this template
By implementing a system where Google Forms responses are automatically reflected in Google Sheets, work efficiency is rapidly improved.
The main advantage is that there is no longer a need to manually transfer data based on responses received in Google Forms, reducing the time and effort required for input.
Additionally, since you can quickly grasp the latest response information just by checking Google Sheets, you can promptly address cases that require action without missing the timing.
The reduced burden of input tasks also makes it easier for staff to focus on other duties.


When a form response is submitted
When a row is added
When a row is updated
Get List of Answers
Get Specific Answer Information
Get List of Responses (Specify Response Period)
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)
Set a value in a cell
Get values
When a form response is submitted
Get List of Answers
Get Specific Answer Information
Get List of Responses (Specify Response Period)
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