Fill the same PDF for each new customer, employee, or project in your Google Sheets™ list. JustFill saves one completed PDF per row to Google Drive™ and reuses the field layout for your next batch.

START WITH TWO SAMPLE ROWS
Install the add-on, open a new empty sheet, and open the JustFill side panel. Connect your JustFill account. Choose "Sample: project intake form" and click "Add column headers". In an empty sheet, this adds seven columns and three rows of fictional data. Click "Check columns", then "Fill rows". Open the output folder and check the PDFs.

USE YOUR OWN RECURRING FORM
1. Open the blank PDF at justfill.app. Review the detected field positions and names, then save it as a template while signed in.
2. Return to Google Sheets™ and reopen the JustFill panel. Choose the saved form, add its column headers to an empty sheet, and enter one record per row.
3. Use "Check columns", set the start and stop rows under "More options", and click "Fill rows". Review the completed PDFs in Drive.
4. For your next batch, reuse the form and select only the new rows to avoid creating old copies again.

Step-by-step setup: https://justfill.app/pdf-mail-merge#google-sheets

You can also use JustFill in Google Drive™: select a PDF, approve access to that file, and fill a form whose reviewed layout you have saved in JustFill. Copies are saved to a "JustFill output" folder.

The original PDF layout is preserved. Flat, non-fillable forms can be prepared in JustFill before reuse. Review field positions and long values before relying on the output. JustFill does not submit or email the documents.

LIMITS AND PRICING
Up to 40 inputs per Drive card and 25 rows per Sheets run. Longer forms can be filled in the web app. Signature fields are left empty. A JustFill account is required. Sample fills use the normal account allowance; output may include a watermark. Plans and one-time packs provide clean-output allowances on the same account. Current prices: https://justfill.app/pdf-mail-merge#pricing

PRIVACY
The add-on works with the current spreadsheet and files you select and approve; it cannot browse the rest of your Drive. JustFill processes the PDF and supplied values on its servers. Data handling: https://justfill.app/privacy#google-user-data

Google Drive™, Google Sheets™ and Google Workspace™ are trademarks of Google LLC. JustFill is not affiliated with Google LLC.