Create QuickBooks Online Invoices from PDF Data Using PDF.co and Zapier

Step 1: Set Up the Trigger

Create a Zap and select Google Drive → New File in Folder.

Connect your Google account, choose the invoice folder, and test the trigger. Select your sample PDF.

For this example, use a folder dedicated to invoices for one customer so you can select that customer consistently in QuickBooks.

Step 2: Configure AI Invoice Parser

Add PDF.co → AI Invoice Parser.

Connect your PDF.co account through OAuth, sign in, and authorize access.

Configure:

• Source PDF URL: Map the Google Drive File value from the trigger.
• customField: Leave blank unless you need additional invoice fields.
• lineItemStructure: Leave blank to use the standard line-item structure.

The parser detects invoice layouts automatically. Keep all pages of a single invoice together in one PDF. See the AI Invoice Parser documentation.

Step 3: Test and Review the Extracted Data

Test the PDF.co action and inspect its returned invoice data.

Compare the invoice number, customer, dates, line-item descriptions, quantities, prices, and totals against the source PDF. Use these returned fields when configuring QuickBooks.

Step 4: Create the QuickBooks Invoice

Add QuickBooks Online → Create Invoice and connect your QuickBooks account.

Configure the invoice:

• Customer: Select the existing customer matching the PDF.
• Invoice Number: Map the extracted invoice number. Disable automatic numbering if you want to preserve it.
• Invoice Date: Map the extracted invoice date.
• Due Date: Map the extracted due date, if present.

In the line-item section:

• Product/Service: Select or map the corresponding QuickBooks item.
• Description: Map the extracted item description.
• Quantity: Map the extracted quantity.
• Rate: Map the extracted unit price.
• Amount: Map the extracted line amount where required.

For multiple items, map matching line-item lists into the same action so they form one invoice. Do not create a separate invoice for each line. QuickBooks’ action supports multiple line items. QuickBooks action reference

Configure taxes, discounts, and currency as appropriate for the source invoice and your QuickBooks company.

Step 5: Test the Invoice Creation

Testing this action creates a real invoice in the connected QuickBooks company.

Run one test, open the created invoice, and check the customer, line items, dates, taxes, and total against the PDF. Avoid repeating the test unnecessarily, as it can create duplicate invoices.

Step 6: Publish the Zap

Publish the Zap after verifying the results. Add each PDF only once to the monitored folder, and review newly created invoices before sending them to customers.