Summarize Google Forms responses with Gemini, create a PDF, and send it by email
Launch this workflow to connect
Gemini &
Gmail &
Google Forms &
Google Sheets
!
■Overview
Reviewing and summarizing survey responses or inquiries collected through Google Forms one by one, then sharing them with the relevant stakeholders, can be a time-consuming task. With this workflow, whenever a new response is submitted to Google Forms, Gemini automatically summarizes the content and generates a PDF, which is then sent to the designated recipients via Gmail. Eliminate the time spent manually compiling and sharing information, and keep everyone aligned faster.
■Recommended for
- Those who want to streamline the summarization and sharing of information collected through Google Forms
- Those who want to use generative AI, such as Gemini, to automate daily writing and organization tasks
- Those who spend too much time on regular reporting and want to focus on their core responsibilities
■Benefits of using this template
- Automate the entire process—from receiving form responses to summarizing, creating a PDF, and sharing it via email—to reduce the time spent on manual reporting.
- Prevent human errors such as transcription mistakes, missing information in summaries, and forgetting to share updates with stakeholders, improving operational accuracy.
■Flowbot steps
- First, connect Google Forms, Gemini, Google Sheets, and Gmail to Yoom.
- Next, select Google Forms as the trigger and set the action to “When a response is submitted to a form.”
- Then, set the Google Forms “Get specific response information” action as an operation to retrieve the form response.
- Next, set the Gemini “Generate content” action as an operation and instruct it to summarize the retrieved response.
- After that, set the Google Sheets “Issue a document” action as an operation to create a PDF containing the summary generated by Gemini.
- Finally, set the Gmail “Send an email” action as an operation, attach the created PDF, and send it to the designated email address.
※“Trigger”: An action that starts the flow. “Operation”: An action that processes data within the flow after the trigger starts.
■Customization options
- With Gemini’s “Generate content” action, you can freely customize the instructions (prompt) to suit your needs, such as “Summarize in bullet points” or “Extract the three most important points.”
- In the Gmail email-sending operation, you can specify the notification recipients in the To, Cc, and Bcc fields.
- You can freely include information such as the summary text generated by Gemini and the respondent’s name retrieved from Google Forms in the email subject and body. You can also add a fixed greeting or signature.
■Notes
- Connect Google Forms, Gemini, and Gmail to Yoom.
- You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes.
- Available minimum trigger intervals vary by plan.
- For instructions on how to retrieve response details when using Google Forms as the trigger, see “How to retrieve response details with the Google Forms trigger.”
Check Out Similar Templates!
Analyze the content posted on Google Chat using the Gemini assistant and update the response back to Google Chat.
The content posted on Google Chat is analyzed using the Gemini assistant, and the response is updated back to Google Chat. This allows the person in charge to efficiently handle even advanced questions, leading to improved productivity for the entire team.
Analyze the content posted on Microsoft Teams using the Gemini assistant and update the response back to Microsoft Teams.
The content posted on Microsoft Teams is analyzed using the Gemini assistant, and the response is updated again in Microsoft Teams. This flow can improve the efficiency and speed of customer support, leading to enhanced customer satisfaction.
Analyze the content posted on Slack using Gemini's assistant and update the response back to Slack.
The content posted on Slack is analyzed using Gemini's assistant, and the response is updated on Slack again. This not only aids in the development of the person in charge but also reduces workload, allowing them to focus on more important tasks.
See more
About the Apps
Gemini
Related apps
Templates using
Gemini
After completing the form, summarize with Gemini and add it to Google Sheets.
The workflow involves summarizing form responses with Gemini and automatically adding them to a Google Spreadsheet. This reduces the hassle of data organization and manual input, thereby enhancing operational efficiency.
Analyze the content posted on Google Chat using the Gemini assistant and update the response back to Google Chat.
The content posted on Google Chat is analyzed using the Gemini assistant, and the response is updated back to Google Chat. This allows the person in charge to efficiently handle even advanced questions, leading to improved productivity for the entire team.
Analyze the content posted on Microsoft Teams using the Gemini assistant and update the response back to Microsoft Teams.
The content posted on Microsoft Teams is analyzed using the Gemini assistant, and the response is updated again in Microsoft Teams. This flow can improve the efficiency and speed of customer support, leading to enhanced customer satisfaction.
Gmail
Related apps
Templates using
Gmail
Activate the flow bot at the end of each month to send an email in Gmail.
This is a flow that is triggered at the end of each month to send an email via Gmail. It can be used for various purposes such as aggregation processing in Microsoft Excel or monthly invoice issuance.
Add Gmail inbox content to Notion
This is a business workflow that automatically adds Gmail received content to Notion. It streamlines email management and information organization, eliminating the need for manual transcription. By ensuring important emails are securely saved and shared, it enhances the team's operational productivity.
Automatically sort incoming emails in Gmail by keywords and forward them to the person in charge.
This is a flow to automatically sort emails received in Gmail by keywords and forward them to the appropriate person in charge. By using this flow, you can detect specific keywords and forward them to the appropriate person. This will likely lead to improved customer response times.
Google Forms
Related apps
Templates using
Google Forms
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.
Google Sheets
Related apps
Templates using
Google Sheets
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
Add order information to WooCommerce when a row is added in Google Sheets.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
Add a new tab to the Google Spreadsheet at the beginning of each month.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
About the apps you use
Gemini
Yoom allows integration with Gemini's API without any coding. You can use Gemini via API to automatically generate content at various times. It is possible to create AI chatbots by integrating with chat tools or automatically store text generated by Gemini by integrating with database services.
see detailsTemplates
After completing the form, summarize with Gemini and add it to Google Sheets.
The workflow involves summarizing form responses with Gemini and automatically adding them to a Google Spreadsheet. This reduces the hassle of data organization and manual input, thereby enhancing operational efficiency.
After completing the form, summarize with Gemini and add it to Google Sheets.
Analyze the content posted on Google Chat using the Gemini assistant and update the response back to Google Chat.
The content posted on Google Chat is analyzed using the Gemini assistant, and the response is updated back to Google Chat. This allows the person in charge to efficiently handle even advanced questions, leading to improved productivity for the entire team.
Analyze the content posted on Google Chat using the Gemini assistant and update the response back to Google Chat.
Analyze the content posted on Microsoft Teams using the Gemini assistant and update the response back to Microsoft Teams.
The content posted on Microsoft Teams is analyzed using the Gemini assistant, and the response is updated again in Microsoft Teams. This flow can improve the efficiency and speed of customer support, leading to enhanced customer satisfaction.
Analyze the content posted on Microsoft Teams using the Gemini assistant and update the response back to Microsoft Teams.
Gmail
Yoom allows you to integrate with Gmail's API without code and automate email sending from Gmail. You can automatically create and send invoices and contracts via Gmail, or automatically reply to inquiries.
see detailsTemplates
Activate the flow bot at the end of each month to send an email in Gmail.
This is a flow that is triggered at the end of each month to send an email via Gmail. It can be used for various purposes such as aggregation processing in Microsoft Excel or monthly invoice issuance.
Activate the flow bot at the end of each month to send an email in Gmail.
Add Gmail inbox content to Notion
This is a business workflow that automatically adds Gmail received content to Notion. It streamlines email management and information organization, eliminating the need for manual transcription. By ensuring important emails are securely saved and shared, it enhances the team's operational productivity.
Add Gmail inbox content to Notion
Automatically sort incoming emails in Gmail by keywords and forward them to the person in charge.
This is a flow to automatically sort emails received in Gmail by keywords and forward them to the appropriate person in charge. By using this flow, you can detect specific keywords and forward them to the appropriate person. This will likely lead to improved customer response times.
Automatically sort incoming emails in Gmail by keywords and forward them to the person in charge.
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
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 Google Sheets
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 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 Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see detailsTemplates
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Add order information to WooCommerce when a row is added in Google Sheets.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
Add order information to WooCommerce when a row is added in Google Sheets.
Add a new tab to the Google Spreadsheet at the beginning of each month.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Add a new tab to the Google Spreadsheet at the beginning of each month.
No-Code API Actions
Executable API actions
Flowbot triggers
Flowbot operations
Flowbot triggers
There is no action.
Flowbot operations
Flowbot triggers
Flowbot operations
Flowbot triggers
Flowbot operations
Flowbot triggers
Flowbot operations
More inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!