Google Sheets and PDF4me Integration
Demonstration of how apps are integrated in WEXTL workflow builder[4]
Build developer tools workflows between Google Sheets and PDF4me on a visual canvas. Set up data fields sync between apps once and let data flow when events come automatically. Integration will work without code and your team will see the workflow inside WEXTL® builder.
- 3-day trial
- Cancel anytime
- Up to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Google Sheets and PDF4me
Detailed info you need to know about Google Sheets and PDF4me integrations in WEXTL. Explore which modules apps support and how you connect them.
Google Sheets

Read, write, append, and batch-update spreadsheet data in Google Sheets with dynamic sheet pickers.[5]
PDF4me

Document processing that converts, edits, merges, splits and extracts PDFs.[6]
How to connect Google Sheets to PDF4me
Set up your Google Sheets and PDF4me integration in 3 simple steps[2]. No coding required. Up to 10 minutes setup.
STEP 1
Connect Google Sheets and PDF4me
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow[3]. No coding or API skills required.
STEP 2
Build a workflow
Paste selected Google Sheets and PDF4me nodes onto the canvas[4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between Google Sheets and PDF4me. Use filters or a JS custom code step in between. Everything is on the canvas.
How does the integration between Google Sheets and PDF4me work in WEXTL?
WEXTL exposes actions and triggers for Google Sheets and PDF4me that help you connect apps and automate repetitive tasks[1]. A trigger is an event that happens, and an action is a step that performs when the event has occurred.
Google Sheets triggersPDF4me actions
Google Sheets modules
- Append a Row Adds one row to the end of a sheet and fills each column header with its value. Use Value Input Option to treat input as RAW or as USER_ENTERED.
- Append Multiple Rows Writes many rows below the data of a sheet in one request. Use Rows to list them, and Insert Data Option to overwrite existing cells or insert new rows.
- Append Values Places values below the existing data of a range, located by Spreadsheet ID, Sheet Name and Range or by Select From Drive. Turn on Include Values In Response to return the written cells.
- Batch Clear Values Clears the values of several A1 ranges in one request. Returns Spreadsheet ID and Cleared Ranges. Clear Values handles a single range.
- Batch Clear Values by Data Filter Clears the values of all ranges that match your Data Filters. The result lists the Spreadsheet ID and Cleared Ranges.
- Batch Get Values Reads several ranges in one call and returns them as Value Ranges. Use Value Render Option for formulas or computed values and Date Time Render Option for serial numbers or formatted dates.
- Batch Get Values by Data Filter Reads all ranges matched by your Data Filters, with no fixed A1 addresses. Returns each matched range as Value Ranges. Use Major Dimension for rows or columns.
- Batch Update Spreadsheet Applies a list of Requests to a spreadsheet, such as addSheet, merge cells or repeatCell formatting. Returns the Replies. Turn on Include Spreadsheet In Response to get the updated file.
- Batch Update Values Writes several ranges in one request from Data. Use Value Input Option to set how values are parsed. Returns totals for updated rows, columns, cells and sheets, plus per-range Responses.
- Batch Update Values by Data Filter Writes your Data into the ranges that Data Filters match instead of fixed cell addresses. The result gives updated cell totals and per-range Responses.
- Clear Values Clears the values of one range and keeps its formatting. Returns the Cleared Range. Batch Clear Values handles several ranges.
- Copy a Sheet to Another Spreadsheet Copies a sheet tab into a Destination Spreadsheet. Returns the Sheet ID, Title and Index of the copy.
- Create a Spreadsheet Creates a spreadsheet with a Title, plus optional Locale, Time Zone, Auto Recalc and starting Sheets. Returns the Spreadsheet URL and ID.
- Get a Developer Metadata Entry Reads one developer metadata entry of a spreadsheet by its Metadata ID. Returns the Metadata Key, Metadata Value, Visibility and Location.
- Get a Spreadsheet Returns the properties of a spreadsheet and its list of sheets. Trim the output with Ranges and Fields. Set Include Grid Data to add cell contents.
- Get a Spreadsheet by Data Filter Returns a spreadsheet with grid data limited to what your Data Filters select. Set Include Grid Data to add the matching cells.
- Get Values Reads the cells of one range. Returns the Range, its Major Dimension and a Values array. Set Value Render Option for formatted, unformatted or formula output.
- Make an API Call Calls the Google Sheets REST API directly with a free-form request under your saved credential.
- Search Developer Metadata Finds developer metadata entries that match your Data Filters and returns them as Matched Developer Metadata.
- Update Values Overwrites one range with Values. Set Value Input Option to read input as RAW or USER_ENTERED. Returns the Updated Range and counts of updated rows, columns and cells.
- Watch New Rows Checks a sheet on your schedule and starts the workflow once for every row added since the last check. Each row brings its Row Number, the sheet name and its cell Values.
PDF4me modules
- Add a Barcode to a PDF Stamps a barcode of your Text onto selected Pages, in one of the Barcode Type options PDF4me supports. Place it with Horizontal Alignment, and size it with Height (mm) and Width (mm).
- Add a Margin to a PDF Adds margins of 0 to 100 millimetres on each side of a PDF page.
- Add a Page Number to a PDF Prints a page number on each page using a Format such as # of {1}, where # is the page number and {1} the total. Use Horizontal Alignment and Vertical Alignment to place it, and set Skip First Page to leave the first page unnumbered.
- Add a Text Header and Footer to Excel Sets text across Header Left, Header Center, Header Right and the three footer areas, with a Color and font size for each part.
- Add a Text Stamp to a PDF Stamps your Text on selected Pages, styled with Font, Font Size, Font Color and Rotation. Turn on Place in Background to put it behind the content.
- Add a Text Watermark to an Image Draws a Text watermark on an image in a chosen Font, Font Size and Color. Place it with Position, or fine tune with Position X and Position Y.
- Add a Text Watermark to Excel Overlays your Text as a watermark on Excel worksheets, with a Font, Text Size, Color, Transparency and Rotation. Limit it to certain sheets with Worksheet Names or Worksheet Indexes.
- Add a Text Watermark to Word Adds a Text watermark such as CONFIDENTIAL or DRAFT to a Word document, styled with Font, Font Size, Color, Orientation and Rotation.
- Add an Attachment to a PDF Embeds one or more files into the PDF as attachments, each with a file name and extension. Returns the File and File Name.
- Add an HTML Header and Footer Puts your HTML in the header or footer of PDF pages, at a Location of your choice. Turn on Skip First Page to leave out page one, and use the margin fields in px for spacing.
- Add an Image Header and Footer to Excel Puts an image into the header or footer of Excel worksheets. Set Put in Header to Yes for the header and No for the footer, and use Worksheet Names or Worksheet Indexes to select sheets. Returns Success and Error Message.
- Add an Image Stamp to a PDF Overlays a stamp image on chosen Pages of a PDF. Set an Opacity for transparency, turn on Place in Background to sit it behind the page content, and Show Only in Print to keep it off the screen.
- Add an Image Watermark to an Image Lays a watermark image over a picture at a chosen Position, with an Opacity and Rotation. Use Horizontal Offset and Vertical Offset to nudge it.
- Add an Image Watermark to Word Places a Watermark Image on a Word document. Use Scale, Width (pt) and Height (pt) for the size, and set Semi-Transparent to make it translucent.
- Add Form Fields to a PDF Puts a form field on a PDF, with a Field Name, Field Type and Initial Value. Use Pages to choose which pages get it, Position X and Position Y to place it, and Size to set how big it is.
- Add Rows to Excel Adds the objects from Rows (JSON) to an Excel file as new rows, on the sheet called Worksheet Name or in the table called Table Name. Use Insert From Row and Insert From Column to set where they start.
- Classify a Document Works out what kind of document a file is, and returns a Document Type, Category, Confidence and Metadata.
- Compare Word Documents Compares a First Document with a Second Document and returns a file marking their differences. Turn on Ignore Formatting, Ignore Comments or Ignore Tables to skip those.
- Compress a PDF Reduces the size of a PDF, using a Profile that balances size against quality.
- Compress an Image Shrinks an image file of the chosen Image Type. Raise the Compression Level for a smaller file at lower quality.
- Convert a Markdown File to a PDF Turns a Markdown document into a PDF. When the file is a ZIP, give the Markdown File Path of the .md file inside it.
- Convert a PDF to an Editable PDF (OCR) Runs text recognition so a scanned PDF becomes editable. Set Quality to Draft for normal PDFs or High for scans. Turn on OCR Only When Needed to skip recognition when the text is already searchable.
- Convert a PDF to Excel Converts a PDF into an Excel workbook. Choose High Quality for scanned documents, and set Merge All Sheets to combine the sheets.
- Convert a PDF to PowerPoint Converts a PDF into a PowerPoint presentation. Use Language to match the text in the file, and set Quality to Draft for normal PDFs.
- Convert a PDF to Word Converts a PDF into a Word document, with High Quality for scans. Change Language only when the output is not recognizable.
- Convert a URL to a PDF Renders the page at a Web URL as a PDF. Use Authentication with a Username and Password for pages behind a login, and the four margins for spacing.
- Convert a Visio File Converts a Visio file to another Output Format. Optional settings cover Page Index, Page Count, Include Hidden Pages, JPEG Quality, Resolution and TIFF Compression.
- Convert a Word File to a PDF Form Turns a Word document into a PDF form, ready for filling in, and returns the File and File Name.
- Convert an Image Format Changes an image from its Current Format to a New Format and returns the converted File.
- Convert HTML to a PDF Renders HTML into a PDF, choosing orientation with Layout and size with Page Format. Use Scale with a decimal from 0 to 0.8 to shrink the content, and Print Background to keep colors and images.
- Convert JSON to Excel Writes JSON data into an Excel workbook. Use Worksheet Name, First Row and First Column to set the sheet and where the data starts, and turn on Bold Title for a bold heading. Returns Rows Processed and Columns Processed.
- Convert to a PDF Converts a document into a PDF, returned as a File with its File Name.
- Create a Barcode Generates a barcode image from Text in your chosen Barcode Type. Turn on Hide Text to drop the label under the barcode.
- Create a PDF/A Converts a document into PDF/A, with its Compliance level selectable. Turn on Allow Upgrade to let PDF4me move to a higher level, and Allow Downgrade for a lower one.
- Create a Swiss QR Bill Builds a Swiss QR bill from the Creditor IBAN, Creditor Name and creditor address. Add a Debtor Name, a Message or Billing Information, or merge it into an Existing PDF.
- Create Images from a PDF Renders PDF pages as images in an Image Format and a Width (px), limited to the Pages listed. Each image becomes a separate item.
- Crop an Image Crops an image by Crop Type, using Left Border, Right Border, Top Border and Bottom Border, or Upper Left X, Upper Left Y, Width and Height.
- Delete Blank Pages from a PDF Removes empty pages from a PDF. Use Blank Page Rule to say which pages count as blank.
- Delete Pages from a PDF Removes specific pages from a PDF, with ranges such as 2-5 or 2- for page 2 to the end.
- Delete Pages from Word Removes pages from a Word file, as a range from Start Page to End Page or as a list of Page Numbers.
- Delete Rows from Excel Deletes the rows covered by Row Ranges, such as 2-5,8, from a worksheet.
- Delete Worksheets from Excel Deletes whole worksheets from an Excel file. Use Worksheet Names or Worksheet Indexes to say which ones.
- Disable Track Changes in Word Stops change tracking inside a Word document and returns the updated File.
- Enable Track Changes in Word Switches change tracking on in a Word document and returns the updated File.
- Extract Attachments from PDF Pulls the attached files out of a PDF. Each one becomes a separate item with its File Name, File and Base64 Content.
- Extract Form Data from PDF Reads the values entered in a PDF form and returns them as Form Fields.
- Extract Pages from PDF Splits chosen pages of a PDF into a new PDF, using ranges like 2-5 or 2- for page 2 to the end.
- Extract Rows from Excel Reads rows from an Excel sheet and gives them back as Rows. Limit the range with First Row, Last Row, First Column and Last Column, and shape each row with Has Header Row and Export as Objects.
- Extract Table from PDF Detects table data in a PDF and returns each table it finds.
- Extract Text and Images from PDF Pulls the words, the pictures or both out of a PDF. Turn on Extract Text, Extract Images or both. Returns Text and Images.
Explore alternative integrations
There are other apps[9] supported by WEXTL that can be paired with Google Sheets and PDF4me integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Google Sheets and PDF4me.
References
List of sources used to gather information about the Google Sheets and PDF4me integration.
- Google Sheets and PDF4me integration source code, module specs and credentials implementation.
- Our Google Sheets and PDF4me integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Google Sheets and PDF4me, used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- Google Sheets integration information
- PDF4me integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library
How we write our apps documentation
Explore how WEXTL® crafted Google Sheets and PDF4me integration page documentation. Used sources, the role of AI, and how the team validates the result.