Add data to Microsoft Excel based on Google Forms responses while excluding duplicates
Add data to Microsoft Excel based on Google Forms responses while excluding duplicates
Launch this workflow to connect
Microsoft Excel &
Google Forms
!
■Overview
Are you manually transferring survey responses or registration details collected through Google Forms to Microsoft Excel?
Copying and pasting each entry and checking for duplicates manually is time-consuming and prone to errors.
With this workflow, you can automatically compare form responses against existing Excel data and add new records only when no duplicates are found.
Eliminate tedious data transfer tasks and keep your lists up to date at all times.
Copying and pasting each entry and checking for duplicates manually is time-consuming and prone to errors.
With this workflow, you can automatically compare form responses against existing Excel data and add new records only when no duplicates are found.
Eliminate tedious data transfer tasks and keep your lists up to date at all times.
■Who Should Use This Template
- Anyone manually transferring information collected through Google Forms to Microsoft Excel
- Teams looking to reduce the time spent checking for and adding duplicate data while preventing human error
- Anyone who wants to automate data entry from forms and focus more time on core business tasks
■Benefits of Using This Template
- Automatically check for duplicates in Excel and add data whenever a form response is submitted, reducing the time spent on manual data entry.
- Prevent human errors such as manual transcription mistakes and duplicate data entries, helping maintain data accuracy.
■Workflow Steps
- First, connect Google Forms and Microsoft Excel to Yoom.
- Next, select Google Forms as the trigger and set the action to “When a response is submitted to the form.”
- Then, select Microsoft Excel as an operation and use the “Retrieve records” action to retrieve the existing data.
- Next, configure branching in the operation to determine whether the form response already exists in the existing records.
- Finally, configure the Microsoft Excel “Add a record” action to add new data only when no duplicate is found.
※ “Trigger”: An action that starts the flow. “Operation”: An action that processes data within the flow after the trigger starts.
■Customization Options
- You can replace Google Forms set as the trigger with other form creation tools integrated with Yoom, such as formrun or Typeform.
- You can customize Microsoft Excel to other database apps, such as Google Sheets or kintone.
- You can set the branching conditions to check for duplicates based on any fields relevant to your business, such as email addresses or phone numbers.
■Notes
- Make sure to connect both Google Forms and Microsoft Excel to Yoom.
- Microsoft 365 (formerly Office 365) offers plans for home use and plans for organizations (Microsoft 365 Business). Authentication may fail if you are not subscribed to an organization plan.
- You can select a trigger interval of 5, 10, 15, 30, or 60 minutes.
- Note that the shortest available trigger interval varies by plan.
- Branching is an operation available on the Personal plan and higher. On the Free plan, the configured workflow operation will result in an error.
- Paid plans, such as the Personal plan, include a two-week free trial. During the free trial, you can use apps and features (operations) that are otherwise subject to restrictions.
- For information on configuring operations that manipulate Microsoft Excel databases, see [Excel] Configuring Operations for Manipulating Databases.
- For information on how to retrieve response data when using Google Forms as a trigger, see How to Retrieve Response Data with the Google Forms Trigger.
Check Out Similar Templates!
See more
About the Apps
Microsoft Excel
Related apps
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.
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.
About the apps you use
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.
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.
No-Code API Actions
Executable API actions
Flowbot triggers
When a Form Response Is Submitted
Flowbot operations
Get Worksheet Information
Get a Specific Cell Value
Get Range by Column
Get Range by Row
Add Worksheet
Rename Sheet
Get 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
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 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)More inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
