This automation scenario allows you to connect Google Forms, PDF Generator API, and Google Drive.
It can be build using Integromat, a no-code workflow automation tool. Integromat allows you to create automated bots using a simple drag-and-drop interface for non-technical users. This is a ready-made scenario, but it can be customized by adding more apps, actions, filters or branches.
When this trigger fires in Google Forms
Watches for new responses in the Google Sheets table.
Then these actions happen in Google Drive and Google Drive
Merges template with data and returns base64 encoded document or a public URL to a document. You can send JSON encoded data in the request body or a public URL to your JSON file as the data parameter. When the public URL option is used, the document is stored for 30 days and automatically deleted.
Uploads a new file.
This guide contains information on how to set up an automatic workflow that allows to Generate a PDF via PDF Generator API from a Google Form response and save it to Google Drive.
Part I
First, we need to connect Google Forms, PDF Generator API and Google Drive to Make.com.
Create Make.com account.
Create Make.com account if you don't have one.
Connect Google Forms to Make.com.
Give Make.com access to your Google Forms account, using Google Forms credentials.
Connect PDF Generator API to Make.com.
Give Make.com access to your PDF Generator API account, using PDF Generator API credentials.
Connect Google Drive to Make.com.
Give Make.com access to your Google Drive account, using Google Drive credentials.
Part II
Next, we need to create a workflow automation scenario using graphical no-code web interface of Make.com.
Set up a Trigger action for Google Forms
Choose the following trigger: Watch Responses in Google Sheets (Watches for new responses in the Google Sheets table.).
Then set up an Action for PDF Generator API
Choose this action: Generate Document (Merges template with data and returns base64 encoded document or a public URL to a document. You can send JSON encoded data in the request body or a public URL to your JSON file as the data parameter. When the public URL option is used, the document is stored for 30 days and automatically deleted.).
Then set up another Action for Google Drive
Choose this action: Upload a File (Uploads a new file.).
Part III
Finally, we need to test this automation and publish it.
Customize data flow
Configure the data that is exchanged between Google Forms, PDF Generator API and Google Drive.
Test the workflow and turn it on for production use
Test your scenario and publish to production. Now you have an automatic workflow, that will Generate a PDF via PDF Generator API from a Google Form response and save it to Google Drive!
Triggers when a new file is created within a specific folder (but not its subfolders). Please note for files moved to a folder, this trigger may not work as expected, use the newer version for that use case.
Triggers when any new file is added (inside of any folder).
Triggers when there is a new file in a specific folder
Triggers when a file is created or modified in a selected folder.
Triggers when a file is updated in a specific folder (but not its subfolders).
This trigger fires every time a new file is added to the Google Drive folder you specify. Note: Does not work for Google Docs, Forms, or Sheets files.
Create a new response/entry (row) in a specific spreadsheet.
Merges template with data and returns base64 encoded document or a public URL to a document. You can send JSON encoded data in the request body or a public URL to your JSON file as the data parameter. When the public URL option is used, the document is stored for 30 days and automatically deleted.
This is an advanced action which makes a raw HTTP request that includes this integration's authentication.
Create a new action using AI.
Finds a response row by a column and value. Returns all the values on that matching row.
Updates a response in the Google Sheets table.
Google Forms is a user-friendly tool for gathering data and conducting surveys online. It offers customizable forms, real-time collaboration, and seamless integration with Google Sheets. Create, share, and analyze responses effortlessly.
API and a template builder for creating PDF documents from Your software
PDF Generator API helps to generate PDF documents from PDF templates, using JSON data. Users can edit document templates with online GUI and use their own data to generate a document. You can create invoices, packing slips, contracts or labels.
Google Drive is a versatile cloud-based platform that lets you store your files, photos, videos, and more safely. You can access them from anywhere and share with others, making collaboration a breeze.
Make.com (Integromat) is a powerful automation tool that enables users to connect their favorite apps, services, and devices without any coding skills. With its unique features, users can automate even complex integrations easily and efficiently, saving time and effort. Integromat allows to connect apps and automate processes in a few clicks.