Established API Integration with Airtable in Google Sheets

Job Description

I'm looking to have a Google Sheets created where I input information that then transfers that data to airtables which then fills in the data on multiple PDF documents, which then gets emailed to me.

Further explanation:

I need a Google Sheets created similar to the attached file called Google Sheets example. The input fields should be the same with a cell that an email address could be input to direct where the final output pdf file should be emailed.

The cells under the "Paste Here" cell should allow for copying and pasting from the Data Input PDF to these cells directly.

Once a user inputs the data in the cells and clicks the "create printing slip" button, the data in the cells should be transferred to airtables and the output PDF files should be generated for each of the rows in the "paste here" column of the google sheet.

I've attached the required output for the 1st row of data for route number C007.

The generated PDF's for all the rows should be combined and emailed to the email address that was input in the cell under "send email to".

There's one additional cell that needs to be created in the Google Sheets. It's the information that will be put in the "delivery type" box of the output PDF. You can make this a selection in the Google Sheets if you'd like or you could make it a custom fill in cell, whichever is easier.

There's only 2 options for this new cell, which is:

1. Residential

2. Business & Residential

I would like complete control over the Google Sheets created and you will be creating the airtable in my airtable account.

Works with Apps

Airtable Google Sheets Gmail Google Docs

From Ashton

In this project, we utilized Google Apps Script to automate the process of PDF generation, establishing API integration with Airtable within Google Sheets. Additionally, Gmail API services were employed to facilitate the sending of notifications.

Hire Me on Upwork

From Client

Ashton is truly a pleasure to work with. No nonsense, no fluff, a professional who performed exceptionally and delivered everything asked of him. One of the rare few providers I have saved for future jobs.

Google Apps Script Projects Shared On YouTube

Links

Work with Me on Upwork YouTube Twitter / X Automate The Boring (Blog)