Airtable Extension
Generate/Populate/Merge documents from your Airtable records
Last updated
Was this helpful?
Generate/Populate/Merge documents from your Airtable records
Last updated
Was this helpful?
Docupilot's Airtable extension allows you to create your Contracts, Sales/Purchase Orders, Invoices, Employment Offer Letters, Real Estate Agreements, Marketing material and many more professional documents in PDF, Word, Powerpoint, Excel and other formats.
In the Airtable base, click on the Extensions button present on the RHS. A dialogue box will be displayed. Now, click on the button Add an extension in the dialogue box.
Once the button Add an extension is clicked, a pop-up of Airtable Marketplace will be displayed on the screen. In the pop-up search for Docupilot and click on it.
Once Docupilot is selected, the following will be displayed on the screen. Here click on Add extension. After doing so, a small pop-up will be displayed, click on Add extension button on the pop-up too.
After clicking on Add extension, a pop-up of Docupilot will be displayed consisting of instructions to set up an API key and secret. Follow the steps and set up the key and secret on Docupilot after which click on Get Started button on the pop-up.
On the following page, paste the API key and secret into their corresponding slots and click on save.
Now the Docupilot extension is installed successfully onto the Airtable base.
After the installation of the Airtable extension to the base, the first step towards document generation would be selecting the record(s) and the template.
Once the record and the template have been chosen, we can see that a few fields will be pre-mapped based on the field name and the token name.
The remaining fields need to be mapped manually.
After all the fields are mapped, clicking on the Generate document button will start document generation and one document will be generated for each record selected.
For example, if 5 records are selected then 5 documents will be generated.
The generated document can either be saved into an attachment row in the Airtable base or can be delivered using the mode of delivery that is assigned to the template.
To be able to automatically generate documents as part of your Airtable Automation setup, you can use the custom script generated by our Extension in "Run a Script" step.
To generate the code:
Select a record from your Airtable base
Select desired template from the Extension
Configure attachment field if desired
Map the fields
Click on the "Generate Automation Code" ( < > ) button to generate the automation script
Use generated code in automations:
Copy the generated script
Paste it in your automation "Run a Script" step
Add an input variable "recordURL" and map it to "Base Record URL"
You can append up to 10 PDFs using the "Append PDF" option available in Docupilot's Airtable extension.
In Airtable, select the row(s) containing the PDFs you want to append. Then, navigate to the Append PDF tab in the Docupilot extension.
From the dropdown, select the attachment field where the appended PDF should be uploaded.
If you have multiple attachment fields, select all the columns from which the attachments are to be appended.
Please note that the order of your selection will determine the sequence in which the files are appended.
Click Append Documents. This will combine all selected files and place a single document in the chosen column of the respective row.
