Get PDF Info and Send to Airtable using Make

Step 1: Airtable Search Records

To begin, we will set up the integration with Airtable's Search Records feature to either search for specific records or fetch all records.

Step 2: Setup Airtable Configuration

• Input the name of your Airtable base in the "Base" field.
• Select the name of your Airtable table from the "Table" field.
• Next, choose the Grid View option.
• Select the Output fields where the PDF file is stored.

Step 3: Add PDF.co Module

We will now use the PDF.co Get PDF Information feature to extract information from the PDF document.

Step 4: Setup PDF.co Module

Choose the Import a File from URL option to load the PDF attachment URL.

Select the PDF attachment URL from Airtable.

Step 5: Run Scenario to Get PDF Information

Now, execute the scenario to extract the PDF information.

Step 6: Airtable Update Record

Once the PDF information has been extracted, we will proceed to update the record in Airtable.

Step 7: Update the Matching Airtable Record

Configure Airtable → Update a Record:

• Base: Select the base used by the source Search Records module.
• Table: Select the source table.
• Record ID: Map the record ID from the same Airtable → Search Records bundle that supplied the PDF being processed.
• Record fields: Map the extracted PDF properties into the corresponding Airtable fields.

The PDF.co Get PDF Information output includes a Body containing properties such as PageCount, Title, and Author. Inspect a test result to select the appropriate values.

Keep each record ID associated with its PDF throughout the scenario. Do not enter one fixed record ID when processing several records, as subsequent results could overwrite that record.

If a source record contains multiple PDF attachments, explicitly choose which attachment its metadata fields describe. Processing every attachment into the same fields would leave only the last update’s values.

Test the Record Mapping

Start with two records containing PDFs with different known page counts—for example, one page and three pages.

Run the scenario and confirm that:

• Each update targets its corresponding source record.
• Each record receives its own PDF’s page count and metadata.
• Neither update overwrites the other record’s results.

Verify both records before increasing the number of records processed.

Step 8: Run Scenario to Update Record

Now, let’s proceed with running the scenario to update the record in the Airtable table. Afterwards, access your Airtable table to see the updated record.

Step 9: Updated Table Records

Here is the Airtable table displaying the updated record containing the PDF information.