Automate Google Sheets with TypeScript
Read, write, format, append, find, and upsert spreadsheet rows and values from TypeScript.
import { automation, onHttpRequest } from "automate.ax"
import { googleSheets } from "automate.ax/google-sheets"
export default automation("Append new orders", () => {
const request = onHttpRequest({ scope: "automation" })
googleSheets.appendRows({
spreadsheet: "spreadsheet-id",
source: { table: "OrdersTable" },
rows: [{
"Order ID": request.query.orderId,
Total: request.query.total,
}],
})
})What you can do
Actions
- Read, write, append, and clear values
- Find, insert, update, delete, and upsert rows
- Create and manage spreadsheets, sheets, and tables
- Format, sort, and find or replace ranges
Triggers
No provider trigger is published for Google Sheets yet. Use another trigger, then call its actions.
