What is Zapier?

Zapier is an online automation tool that connects your favorite apps, such as Gmail, Slack, Mailchimp, and over 1,500 more. You can connect two or more apps to automate repetitive tasks without coding or relying on developers to build the integration. It’s easy enough that anyone can build their own app workflows with just a few clicks.

We prepared this step by step tutorial with screenshots on how to make a Zap using PDF.co and Google Sheets, to automatically convert Google Forms responses to a PDF.

This tutorial assumes you have already clicked “View responses in Sheets” in your Form, and that a linked Sheet is present and ready to use.

TL;DR:

  1. Start by clicking on Make a Zap! at the top-right corner of your Zapier dashboard
  2. Under “When this happens …” Choose App & Event search and select Google Sheets from the list of apps
  3. Under Choose Trigger Event select New Spreadsheet Row in Google Sheets
  4. Select or connect your Google account to Zapier
  5. Select the Spreadsheet and Worksheet where the form responses have been saved
  6. On the Find Data step select the detected Spreadsheet and click TEST & CONTINUE
  7. Under “Do this …” Choose App & Event search and select PDF.co from the list of apps
  8. Under Choose Action Event select Anything to PDF converter
  9. Select or connect your PDF.co account to Zapier
  10. Under Customize Pdf To Anything set the Source Type to Raw HTML code as a string and the Input to your desired HTML formatting including data pulled from Sheets
  11. On the Send Data step click TEST & REVIEW, the returned URL is a direct link to the generated PDF.

Step by step guide:

1. Start by clicking on Make a Zap! at the top-right corner of your Zapier dashboard

2. Under “When this happens …” Choose App & Event search and select Google Sheets from the list of apps

3. Under Choose Trigger Event select New Spreadsheet Row in Google Sheets

It should look like this up until this point:

1_Google-Sheets-Trigger-Event

4. Select or connect your Google account to Zapier

5. Select the Spreadsheet and Worksheet where the form responses have been saved

2_Google-Sheets-Customize-Spreadsheet-Row

6. On the Find Data step select the detected Spreadsheet and click TEST & CONTINUE

7. Under “Do this …” Choose App & Event search and select PDF.co from the list of apps

8. Under Choose Action Event select Anything to PDF converter

Zapier - PDF.co - Choose Action Event_v2

9. Select or connect your PDF.co account to Zapier

Connect Zapier to PDF.co

10. Under Customize Pdf To Anything set the Source Type to Raw HTML code as a string and the Input to your desired HTML formatting including data pulled from Sheets

At this point, optional parameters such as the output file Name can be defined.

3_PDF-dot-co-HTML-to-PDF

On the Send Data step click TEST & REVIEW, the returned url is a direct link to the generated file.

Check if everything works correctly and without errors then hit RETEST & CONTINUE

Give a name to your Zap at the top-left corner, then hit Done Editing, you can then TURN ZAP ON

Your Zap Is Ready

Depending on your Zapier plan and settings, your Zaps will trigger and the output and logs can be found in your Tasks History.

Check out our other PDF.co & Zapier tutorials!

Related Pages: