> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.pdfgeneratorapi.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to Integrate with Zapier

Zapier allows transferring generated documents from one system to another. You can find our Zapier app [here](https://zapier.com/developer/public-invite/9534/5bf6a10c643d46fe56c5751b197447bc/).

We can imagine an employee, who works with data in a Google spreadsheet. The spreadsheet is set as an input to the automated process from Zapier, via the API, to the output - PDF Generator. Adding a row to the table of the successful course graduates will trigger the sending of data via the API. The output data are generated into a template certificate.

![Background Logic](https://storage.crisp.chat/users/helpdesk/website/11e0e518fc48ce00/zapierpng_b8t0se.png)

|| Note that even if you would need to set different process, the steps 2 and 3 are basically the same.

### Setup

To use PDF Generator API with Zapier, you need a PDF Generator API account. You can create a [free Sandbox Account](https://us1.pdfgeneratorapi.com/signup) and use it for **14 days** to evaluate and integrate the API, with **up to 50 credits** available during the trial period.

| For more information on how credit usage is calculated, see this [article](https://support.pdfgeneratorapi.com/en/article/how-credit-usage-is-calculated-5820vc/).

##### Prerequisites

* Prepare your own template, or you can use one of our [Example Documents](https://pdfgeneratorapi.com/example-documents). In the article we are working with the "Certificate" example document - you can [download](https://pdfgeneratorapi-web-assets.s3.amazonaws.com/templates/certificate_template_example.json) the template structure and then import it by following this [tutorial](https://support.pdfgeneratorapi.com/en/article/how-to-copy-a-template-from-one-worskpace-to-another-1ufgb2i/).
* Log in/sign up into your Zapier account [using invitation link from PDF Generator API](https://zapier.com/developer/public-invite/9534/5bf6a10c643d46fe56c5751b197447bc/).
* Log in/sign up into your Google Drive account, create new Google Sheet File, name the columns.

![Example Google Sheet Document](https://storage.crisp.chat/users/helpdesk/website/11e0e518fc48ce00/zap2png_twhk8a.png)

### Download the complete Zap file and start your process automation right now!

1. [Upload generated document to your Google Drive](https://zapier.com/shared/26557a1b7c6ad37ca0b5fbff8d7274879842c5ba)
2. [Send generated document to AWS S3 Bucket automatically](https://zapier.com/shared/2e266849c06fc8e9f0f87d09a0324f09bb38b83e)
3. [Generate a document using Postman and send generated document via email automatically](https://zapier.com/shared/b3021342b4d6c33a8afe9cededf01a14fdb96215)

### Create a ZAP and set your step manually

* Once you logged in your Zap account, hover over the left sidebar menu and click Make a Zap.
* Create your steps, as you can see in the picture, follow the videos too see how to set up each step

|| You can also find more information in the [Zapier support portal](https://zapier.com/help).

###### Customize each step to your needs

${frame}[Zapier Setup](https://www.loom.com/embed/f10e9553b57c49d0abc9dbe58b527bb0)

### Step 1 - Google Sheets

Choose your spreadsheet.

### Step 2 - Create Document

There are three "Output" options within this step:

* URL to PDF File
* Raw PDF content
* Base64 encoded

| You should enter the values into "JSON" option manually, copying the well known JSON file logic, in our case: {"Name":"ColumnName1", "DueDate":"ColumnName2"}

### Step 3 - Upload to Google Drive

| In the "Customize Upload File" category as the "File" option should be entered "Document" (PDF Generator API)

In case you would need to save the generated document to AWS S3 Bucket, or send generated document via email, you can find two more tutorials here:

### Send generated document to AWS S3 Bucket automatically

${frame}[AWS S3 Bucket](https://www.loom.com/embed/cdd9605881444fdca0ed0edb4b386e69)

||| When adding an AWS account to Zapier, do not select the location option of the S3 as the "Default" but replace it with the real one, it usually displays an error from the "Default" option

### Send generated document via email

${frame}[Email](https://www.loom.com/embed/c85e24f3c2044db68a039a5984b34fd9)
---
### Related articles you may find helpful

* [Common use-cases of the Expression language](/en/article/common-use-cases-of-the-expression-language-1seclga/)
* [How to use the editor?](/en/article/how-to-use-the-editor-1a194yy/)
* [Which fonts, languages and characters are supported?](/en/article/which-fonts-languages-and-characters-are-supported-meo2d7/)
