Google Sheets and Extend

Google Sheets

Triggers

• Google Sheets New RowTriggers when a new row is added to a Google Sheets spreadsheet.

Actions

• Append rowAppend a single row to the end of a Google Sheet.
• Create spreadsheetCreate a new Google Sheets spreadsheet.
• Delete spreadsheetDelete a Google Sheets spreadsheet permanently.
• Write rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update row.
• Update rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from. A column that doesn't exist yet is added to the header row.
• Clear row valuesClear values in a specific row without deleting the row itself.

Extend

Actions

• Parse a documentTurn a PDF, image, spreadsheet, presentation, or scan into clean, layout-aware markdown split into chunks: ready to feed into a later AI step, a search index, or a RAG pipeline.
• Extract data from a documentPull structured values out of a document (invoice totals, contract dates, form answers) as named fields you can use in later steps. List the fields you want, run an extractor saved in Extend, or leave both blank and let Extend work out the shape of the document for you.
• Classify a documentDecide what kind of document a file is, such as an invoice, a receipt, or a bank statement, from types you describe or a classifier saved in Extend. Use the answer to send each document down the right branch of a workflow.
• Split a documentFind the separate documents inside one file, such as the application, pay stubs, and bank statements in a scanned loan packet, with the pages each one covers. Every part comes back as an Extend file of its own, ready to extract from.
• Fill a PDF formFill in the fields of a PDF form from plain-language instructions, such as 'Set the name to Jordan Avery and tick Single', and save the completed PDF for later steps to email, upload, or sign. Extend finds the form's fields itself.
• Run an Extend workflowStart one of your Extend workflows on a file, with every step you set up in Extend Studio: parsing, classifying, splitting, extracting, validation, and human review. Extend runs it in the background, so this returns the run straight away; read the results with 'Get an Extend workflow run'.