When an application is submitted via Google Forms, automatically transfer it to Excel and send a notification to Slack.
When an application is submitted via Google Forms, automatically transfer it to Excel and send a notification to Slack.
Launch this workflow to connect
Google Forms &
Microsoft Excel &
Slack
!
■Overview
When a Google Form submission is sent, the response content is automatically registered in a specified Excel file and notified to a specified Slack channel.
It can be applied to various purposes such as surveys and inquiry forms.
■Recommended for
1. Those who use Google Forms, Excel, and Slack
2. Those who manage information submitted via Google Forms
3. Those who link Google Form information to Excel
4. Those who want to improve efficiency with Google Forms and Excel
■Benefits of using this template
・Since information submitted via Google Forms can be automatically registered in Excel, centralized management becomes possible.
・Automatic linking reduces work time and transcription errors.
・As soon as there is a response to the Google Form, you will be notified on Slack, allowing you to quickly catch the information.
■How to set up
Link each of the apps Google Forms, Microsoft Excel, and Slack with Yoom. (My App Integration)
Set the form ID with the trigger "When a response is submitted to the form" and run a test.
If the test is successful, you can obtain the form response information, so select the information you want to obtain from the response information with the [+] mark button and store it in the output.
※ For how to obtain response content with the Google Form trigger, please refer to the following.
In the "Operate Database" operation, add the obtained information to the Excel file with the action to add a record to Microsoft Excel. Set the columns set in the Excel file to correspond with the read items.
In the Slack "Send a message to a channel" operation, set it to send the extracted information to a specified channel.
■Notes
・Account linking for Google Forms, Microsoft Excel, and Slack is required.
・Please change the question content of Google Forms and the format of the notification message as needed.
Check Out Similar Templates!
Add Google Form responses to Google Sheets
When there is a response to a Google Form, the flow is to register the response in a Google Spreadsheet. Normally, when a response is submitted to a Google Form, the data is added to a specified Google Spreadsheet. However, in this flow, it is possible to add data to any specified Google Spreadsheet without complex settings in Google App Script. Additionally, it saves the effort of repeatedly entering data, allowing work to proceed smoothly, and records can be easily added to the Google Spreadsheet automatically, eliminating any gaps or omissions in information management.
Add Google Form responses to Notion and send event information via Gmail.
This is a business workflow that automatically adds Google Form responses to Notion and sends event information via Gmail. This streamlines data management and information dissemination, making event operations more efficient.
Add a Google Calendar event and send an email based on responses from a Google Forms reservation form.
When a response is submitted to a Google Form, an event is added to Google Calendar and an email is sent. This flow allows for seamless automation from adding the event to sending the email, using only the form responses.
See more
About the Apps
Google Forms
Related apps
Templates using
Google Forms
When there is a response to a Google Form, the flow is to register the response in a Google Spreadsheet. Normally, when a response is submitted to a Google Form, the data is added to a specified Google Spreadsheet. However, in this flow, it is possible to add data to any specified Google Spreadsheet without complex settings in Google App Script. Additionally, it saves the effort of repeatedly entering data, allowing work to proceed smoothly, and records can be easily added to the Google Spreadsheet automatically, eliminating any gaps or omissions in information management.
This is a business workflow that automatically adds Google Form responses to Notion and sends event information via Gmail. This streamlines data management and information dissemination, making event operations more efficient.
Add a Google Calendar event and send an email based on responses from a Google Forms reservation form.
When a response is submitted to a Google Form, an event is added to Google Calendar and an email is sent. This flow allows for seamless automation from adding the event to sending the email, using only the form responses.
Templates using
Microsoft Excel
A business workflow that automatically adds records to Microsoft Excel based on Tally's responses. It eliminates manual data entry, ensuring data accuracy and real-time updates, thereby improving work efficiency and preventing errors.
The workflow automatically records Jotform responses in Excel and adds tasks to Outlook. It eliminates the need for manual data entry and task setting, enhancing the accuracy and efficiency of operations.
This is a business workflow that automatically organizes Microsoft Teams posts into Excel and adds tasks to Outlook. It eliminates the need for manual input, streamlining information and task management.
Templates using
Slack
This is a flow bot that automatically activates at the end of each month and sends notifications via Slack. This flow bot can perform various automated processes through the flows added after the branch on the right side. For example, you can use it for various purposes such as monthly invoice issuance, aggregation processing to spreadsheets, or regular data backup processing.
This is a business workflow that automatically adds content posted in a Slack channel as comments to tasks in Wrike. This reduces manual task updates and improves project management efficiency.
When an inquiry comes to Slack, it is registered in Google Sheets. By integrating Slack and Google Sheets, you can eliminate the hassle of operating individual apps and repeatedly entering data, allowing for smoother business operations. Records can be easily added to Google Sheets automatically, preventing any omissions or leaks in information management.
About the apps you use
Google Forms
Yoom allows you to integrate with Google Forms API without any code, enabling you to automate various tasks. For example, you can notify Slack or Chatwork of information submitted via Google Forms, or automatically store information in CRMs like kintone or Salesforce.
see detailsTemplates
When there is a response to a Google Form, the flow is to register the response in a Google Spreadsheet. Normally, when a response is submitted to a Google Form, the data is added to a specified Google Spreadsheet. However, in this flow, it is possible to add data to any specified Google Spreadsheet without complex settings in Google App Script. Additionally, it saves the effort of repeatedly entering data, allowing work to proceed smoothly, and records can be easily added to the Google Spreadsheet automatically, eliminating any gaps or omissions in information management.
Add Google Form responses to Google Sheets
This is a business workflow that automatically adds Google Form responses to Notion and sends event information via Gmail. This streamlines data management and information dissemination, making event operations more efficient.
Add Google Form responses to Notion and send event information via Gmail.
Add a Google Calendar event and send an email based on responses from a Google Forms reservation form.
When a response is submitted to a Google Form, an event is added to Google Calendar and an email is sent. This flow allows for seamless automation from adding the event to sending the email, using only the form responses.
Add a Google Calendar event and send an email based on responses from a Google Forms reservation form.
Microsoft Excel
Yoom allows you to integrate with Microsoft Excel's API without any code, enabling the automation of various tasks. For example, it can automatically store values in specific Excel cells or create sheets and tables automatically.
see detailsTemplates
A business workflow that automatically adds records to Microsoft Excel based on Tally's responses. It eliminates manual data entry, ensuring data accuracy and real-time updates, thereby improving work efficiency and preventing errors.
Add records to Microsoft Excel based on Tally's responses.
The workflow automatically records Jotform responses in Excel and adds tasks to Outlook. It eliminates the need for manual data entry and task setting, enhancing the accuracy and efficiency of operations.
Add tasks to Microsoft Excel and Outlook based on Jotform responses.
This is a business workflow that automatically organizes Microsoft Teams posts into Excel and adds tasks to Outlook. It eliminates the need for manual input, streamlining information and task management.
Add tasks to Microsoft Excel and Outlook based on Microsoft Teams posts.
Slack
Yoom allows you to utilize Slack's API without any coding. By integrating Yoom with Slack, you can freely connect various SaaS with Slack and receive all kinds of notifications on Slack. Additionally, it is possible to trigger a bot when a message is sent to Slack.
see detailsTemplates
This is a flow bot that automatically activates at the end of each month and sends notifications via Slack. This flow bot can perform various automated processes through the flows added after the branch on the right side. For example, you can use it for various purposes such as monthly invoice issuance, aggregation processing to spreadsheets, or regular data backup processing.
Activate the flow bot at the end of each month and notify Slack.
This is a business workflow that automatically adds content posted in a Slack channel as comments to tasks in Wrike. This reduces manual task updates and improves project management efficiency.
Add a comment to a Wrike task when a post is made in a Slack channel.
When an inquiry comes to Slack, it is registered in Google Sheets. By integrating Slack and Google Sheets, you can eliminate the hassle of operating individual apps and repeatedly entering data, allowing for smoother business operations. Records can be easily added to Google Sheets automatically, preventing any omissions or leaks in information management.
Add inquiry content from Slack to Google Sheets
No-Code API Actions
Executable API actions
Flowbot triggers
When a form response is submitted
When a message is posted to a channel
When a file is posted to a channel
When a message is posted to a channel (Webhook)
When a reaction is added to a message (Webhook)
When a user is mentioned in a channel
When a message containing specified text is posted to a channel
When your Slack app is mentioned (Webhook)
When mentioned in a channel (multiple users)
When a message containing specified text is posted to a channel (Regular expression)
When a new channel is created (Webhook)
When a message is posted in a thread (Webhook)
When mentioned in a channel (multiple users & user groups)
When a reaction is removed from a message (Webhook)
Flowbot operations
Get response list
Retrieve a specific response
Get response list (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 a specific cell value
Flowbot triggers
When a form response is submitted
Flowbot operations
Get response listRetrieve a specific responseGet response list (specify response period)Get Form QuestionsUpdate Form Title and DescriptionUpdate Question Titles and DescriptionsCreate a new formUpdate form visibility settingsAdd 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)
Flowbot triggers
There is no action.
Flowbot operations
Get worksheet informationGet a specific cell valueGet range by columnGet range by rowAdd worksheetRename sheetGet table listAdd TableEnter Formula in CellEnter Value in CellGet item IDDelete SheetSort a specified range in ascending or descending orderUnprotect WorksheetGet Drive Item ID from Sharing URLCreate Excel SessionList sitesList drives in siteGet worksheet information (SharePoint)Get the value of a specific cell (SharePoint)Get range by column (SharePoint)Get range by row (SharePoint)Add worksheet (SharePoint)Rename worksheet (SharePoint)Get table list (SharePoint)Add table (SharePoint)Set formula in cell (SharePoint)Set value in cell (SharePoint)Delete sheet (SharePoint)Sort a specified range in ascending or descending order (SharePoint)Unprotect worksheet (SharePoint)Create Excel Session (SharePoint)Get Item ID (SharePoint)
Flowbot triggers
When a message is posted to a channelWhen a file is posted to a channelWhen a message is posted to a channel (Webhook)When a reaction is added to a message (Webhook)When a user is mentioned in a channelWhen a message containing specified text is posted to a channelWhen your Slack app is mentioned (Webhook)When mentioned in a channel (multiple users)When a message containing specified text is posted to a channel (Regular expression)When a new channel is created (Webhook)When a message is posted in a thread (Webhook)When mentioned in a channel (multiple users & user groups)When a reaction is removed from a message (Webhook)
Flowbot operations
Send message to channelSend direct messageGet member IDs in a channelCreate channelInvite members to channelGet user group listPost message to threadArchive channelGet messages in a threadList public channelsRemove a member from a private channelFind user by email addressGet user infoGet a specific messageGet message linkDelete messageGet users in a user groupGet reactions for a messageCreate a user groupList channel messagesSend a message to a channel with attachmentsList rows in a listCreate listUpdate listGet a specific list rowRemove list accessMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
