When a Microsoft Word file is submitted via Google Forms, use RPA to convert it to PDF and save it to OneDrive
When a Microsoft Word file is submitted via Google Forms, use RPA to convert it to PDF and save it to OneDrive
Launch this workflow to connect
Google Forms &
Google Drive &
Microsoft OneDrive
!
■Overview
Do you manually convert Microsoft Word files received through Google Forms to PDF one by one? These repetitive tasks are time-consuming and can take time away from other important work. This workflow uses an RPA to automatically convert files to PDF when a file is submitted through Google Forms, then saves the converted file to a specified OneDrive folder. Eliminate the hassle of file conversion and organization while improving operational efficiency.
■Who should use this template
- Anyone who finds it time-consuming to convert Microsoft Word files received through Google Forms to PDF
- Anyone who wants to prevent files from being misplaced or human errors during manual conversion
- Anyone who wants to automate repetitive file conversion tasks and focus more time on important core work
■Benefits of using this template
- Automate the entire process from PDF conversion to storage when a file is submitted through the form, reducing the time previously spent on these tasks.
- Eliminate manual file conversion and upload tasks to help prevent human errors such as forgetting to convert a file or saving it to the wrong location.
■Flow overview
- First, connect Google Forms, Google Drive, and OneDrive to Yoom.
- Select Google Forms as the trigger, set it to “When a response is submitted to the form,” and specify the form to monitor.
- Set up Google Drive’s “Download a file” action to download the Microsoft Word file received through the form.
- Next, use the RPA feature’s “Operate browser” action to operate an online conversion tool or similar service and convert the downloaded file to PDF.
- If needed, use the AI feature’s “Extract data from text” action to retrieve information such as the file name for use in subsequent steps.
- Finally, set up OneDrive’s “Upload a file” action to save the converted PDF file to the specified folder.
※“Trigger”: An action that starts the flow. “Operation”: An action that performs processing within the flow after the trigger starts.
■Customization options
- In the Google Forms trigger settings, specify the form that you want to start the workflow.
- In the Google Drive action, dynamically set the ID of the file to download based on the information retrieved in the previous step.
- With the RPA feature, you can freely configure the URL of the website used for PDF conversion, the buttons to click, and other actions to match your environment.
- With the AI feature, you can specify the items to extract from information such as the file name and flexibly use them in later steps, such as setting them as the file name.
- In the OneDrive upload settings, you can freely choose whether to use fixed values or information retrieved in the previous step for the destination folder and file name.
■Important notes
- Connect Google Forms, Google Drive, and OneDrive to Yoom.
- For details on how to retrieve response content when using Google Forms as the trigger, see below.
https://intercom.help/yoom/en/articles/6807133 - **Microsoft 365 (formerly Office 365)** offers plans for home users and businesses (Microsoft 365 Business). If you are not subscribed to a business plan, authentication may fail.
- You can select a trigger interval of 5, 10, 15, 30, or 60 minutes.
- Please note that the shortest available trigger interval varies by plan.
- The maximum file size available for download is 300 MB. Depending on the app specifications, the limit may be less than 300 MB.
- For details on the file size limits supported by triggers and individual operations, see below.
https://intercom.help/yoom/en/articles/9413924 - The browser operation feature is available only on the Success Plan. On the Free, Mini, and Team Plans, workflows containing this operation will result in an error.
- Paid plans, including the Success Plan, offer a two-week free trial. During the free trial, you can use restricted apps and browser operation features.
- For details on how to configure browser operation features, see below.
https://intercom.help/yoom/en/articles/9099691 - Customize the browser operation to match the website you use.
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
Google Drive
Automatically convert PowerPoint files in Google Drive to Google Slides and notify your team in Slack. Eliminate manual conversions and missed sharing to streamline document management and team collaboration.
In this workflow, when a new file is uploaded to Google Drive, the file information is automatically compiled in Notion. This automation facilitates smooth file tracking and sharing, ensuring seamless information sharing within the team.
The workflow automatically saves form responses to Google Drive and registers leads in Salesforce. It enhances data management efficiency and integrates the sales process.
Templates using
Microsoft OneDrive
Using Yoom's Chrome extension, you can create a OneDrive folder with a single click from any page on a Notion database and store the URL of the created folder in any property of Notion. You can create folder names using the information from the properties of the Notion database, allowing you to automatically create folders for each customer or employee. By storing the OneDrive folder URL in the Notion database, you can easily access the created folder directly from the Notion database.
This is a business workflow that automatically analyzes all files in OneDrive using Yoom and ChatGPT to generate Q&A. By analyzing all files in OneDrive with ChatGPT, it automatically generates Q&A that allows quick access to the necessary information.
Automatically upload attachments received via email to OneDrive and notify on Microsoft Teams.
This is a flow that automatically uploads attachments received via email to OneDrive and notifies Microsoft Teams. The files are securely stored in OneDrive, ensuring data consistency and accuracy, facilitating smooth file management and information sharing.
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.
Google Drive
Yoom allows you to integrate with Google Drive's API without any code, enabling the automation of various tasks. For example, you can automatically create new folders in Google Drive and store files, or download files from Google Drive and send them via email or chat.
see detailsTemplates
Automatically convert PowerPoint files in Google Drive to Google Slides and notify your team in Slack. Eliminate manual conversions and missed sharing to streamline document management and team collaboration.
Convert files containing specific keywords created in Google Drive into Google Slides
In this workflow, when a new file is uploaded to Google Drive, the file information is automatically compiled in Notion. This automation facilitates smooth file tracking and sharing, ensuring seamless information sharing within the team.
Create a record in Notion when a new file is added to Google Drive.
The workflow automatically saves form responses to Google Drive and registers leads in Salesforce. It enhances data management efficiency and integrates the sales process.
Add files to Google Drive using form responses and register leads in Salesforce.
Microsoft OneDrive
Yoom allows you to utilize OneDrive's API without any coding. For example, you can automatically upload attachments received via email to OneDrive and send notifications to Slack or Chatwork.
see detailsTemplates
Using Yoom's Chrome extension, you can create a OneDrive folder with a single click from any page on a Notion database and store the URL of the created folder in any property of Notion. You can create folder names using the information from the properties of the Notion database, allowing you to automatically create folders for each customer or employee. By storing the OneDrive folder URL in the Notion database, you can easily access the created folder directly from the Notion database.
Create a OneDrive folder with one click from the Notion database
This is a business workflow that automatically analyzes all files in OneDrive using Yoom and ChatGPT to generate Q&A. By analyzing all files in OneDrive with ChatGPT, it automatically generates Q&A that allows quick access to the necessary information.
Analyze all files in OneDrive with ChatGPT to generate Q&A.
Automatically upload attachments received via email to OneDrive and notify on Microsoft Teams.
This is a flow that automatically uploads attachments received via email to OneDrive and notifies Microsoft Teams. The files are securely stored in OneDrive, ensuring data consistency and accuracy, facilitating smooth file management and information sharing.
Automatically upload attachments received via email to OneDrive and notify on Microsoft Teams.
No-Code API Actions
Executable API actions
Flowbot triggers
When a Form Response Is Submitted
New File or Folder Created
When a New File or Folder Is Created in a Specified Folder
When a Specific File Is Created or Updated
When a File Containing Specific Keywords Is Created
When a File Is Created or Updated in a Specific Folder
When a Folder Is Created or Updated in a Specific Folder
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)
Create Folder
Duplicate File
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
New File or Folder CreatedWhen a New File or Folder Is Created in a Specified FolderWhen a Specific File Is Created or UpdatedWhen a File Containing Specific Keywords Is Created
Flowbot operations
Create FolderDuplicate FileSearch for Files and Folders in a Specific FolderDelete FileUpload FileDownload FileDownload Google Sheets FileDownload Google SlidesDownload Google Docs FileRetrieve a List of Files and Folders in a Specific FolderRename FileRetrieve File or Folder InformationConvert Excel File to Google SheetsConvert CSV File to Google SheetsGrant File or Folder Permissions to a UserMove File to TrashRetrieve a List of Permissions for a File or FolderUpdate Description for a File or FolderChange File Destination FolderCreate a Shortcut to a FileConfigure Download and Copy PermissionsRetrieve a List of Folders in a Specific FolderConvert a File to Google DocsDownload a Google Sheet (Specify Sheet)Change Sharing to "Anyone with the Link"Search Files and Folders in a Specific Folder (Excluding Trash)Convert a Presentation File to Google SlidesConvert a PDF File to Google DocsGrant File or Folder Permissions to a Specific OrganizationUpdate a Specific FileRemove Permissions from a File or FolderCreate a Shared DriveSearch Shared DrivesCopy File (Detailed Options)Search Files and Folders
Flowbot triggers
When a File Is Created or Updated in a Specific FolderWhen a Folder Is Created or Updated in a Specific Folder
Flowbot operations
Search Folders and FilesGet a List of Files in a Specific FolderCreate FolderDownload FileUpload FileCopy a FileCreate Excel FileGrant Permissions to Folder or FileChange Folder or File NameCreate Sharing LinkDelete File/FolderMove File to Another FolderDownload File as PDFGet Top-level Folder ListGet Subfolders of a Specific FolderMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
