To add a row to a Google Sheet using a Node.js step in Pipedream, you can follow this example code. This code assumes you’ve already connected your Google Sheets account to Pipedream and have the necessary permissions to edit Google Sheets. import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, }, async run({ steps, $ }) { const spreadsheetId = "YOUR_SPREADSHEET_ID"; const range = "Sheet1"; // Change to your specific sheet name const values = [ ["Value1", "Value2", "Value3"], // Add the values you want to insert ]; const resource = { values, }; return await axios($, { method: "post", url: `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheetId}/values/${range}:append?valueInputOption=USER_ENTERED`, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }, data: resource, }); }, }); Please replace "YOUR_SPREADSHEET_ID" with your actual Spreadsheet ID and adjust the range to match the name of your sheet. The values array should contain the row data you want to add to your sheet. Each inner array represents a row, and each element within an inner array represents a cell in that row. This code uses the Google Sheets API to append a new row to the specified sheet. The valueInputOption=USER_ENTERED parameter allows the values to be interpreted as if they were entered directly by a user, which means you can use formulas, etc. Remember, for this to work, you need to have the Google Sheets app connected in your Pipedream account with the appropriate permissions to access and modify your Google Sheets data.