Short answer: Use a Google Apps Script that fills a fillable PDF form once for each row of your sheet and saves the filled PDFs in Google Drive. It runs in your Google account and sends what it works on to our server, which does the work. Setup takes 5 steps: Put the form in Google Drive; Set up the sheet; Add the script; Add your key; Run it.
How to set it up
- Put the form in Google Drive. Upload the fillable PDF to Google Drive.
- Set up the sheet. In row 1, use the PDF's field names as column headers. Add one row per person or record.
- Add the script. Open Extensions, then Apps Script. Add two script files and paste in the two files from our email:
Pushbuild.gsandfill-pdf-form.gs. Save, then reload the sheet. A Pushbuild menu appears. - Add your key. Choose Pushbuild, then Set key, and paste the key from your signup email. The first time a script runs, Google asks for permission because it works in your own account. Review it and allow it.
- Run it. Choose Pushbuild, then Fill PDF forms, and paste the PDF's Drive link or file ID. The filled PDFs are saved in a new Drive folder named with today's date.
Want this set up for your business? Free written scope in 20 minutes
Get the script
Download it free
We'll email you the script (Pushbuild.gs and fill-pdf-form.gs) and your key. It runs in your Google account and sends what it works on to our server, which does the work.
Free for your first 10 runs. After that it's $9 a month for this snippet, or $19 a month for every Pushbuild snippet.
Have us install it for you
We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
$49 one-time.
Questions
What does this script do?
It is a Google Apps Script that fills a fillable PDF form once for each row of your sheet and saves the filled PDFs in Google Drive.
How do I set it up?
In 5 steps: 1. Put the form in Google Drive; 2. Set up the sheet; 3. Add the script; 4. Add your key; 5. Run it. The full steps are on this page.
Does it send my data anywhere?
Yes. It runs in your Google account and sends what it works on to our server, which does the work. We email you the script (Pushbuild.gs and fill-pdf-form.gs) and your key.
Can you install it for me?
Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.
Want this connected to the rest of your tools? Send us a short brief.
Pushbuild · Automate your business with Pushbuild: pushbuild.com/