◼️Overview
Automatically input information sent via Google Forms into an Excel table.
Please check this article for how to retrieve responses from Google Forms.
◼️Notes
・Feel free to change the information retrieved from the form and the Excel settings as needed.
・The online version of Excel is required.
・Microsoft365 (formerly Office365) has both a home plan and a general business plan (Microsoft365 Business). If you are not subscribed to the general business plan, authentication may fail.


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)
Get Worksheet Information
Get Specific Cell Value
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)
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session
List sites
List drives in site
Get worksheet information (SharePoint)
Get a specific cell value (SharePoint)
Get a column range (SharePoint)
Get range by row (SharePoint)
Add sheet (SharePoint)
Rename sheet (SharePoint)
List tables (SharePoint)
Add table (SharePoint)
Enter a formula in a cell (SharePoint)
Enter a value in a cell (SharePoint)
Delete worksheet (SharePoint)
Sort a specified range in ascending or descending order (SharePoint)
Unprotect worksheet (SharePoint)
Create Excel Session (SharePoint)