Why Can't Google Sheets Add a Row Using a Variable File Name in a Payroll Spreadsheet?

I apologize for the confusion earlier. Based on your requirements, I’ve made some modifications to the original code to handle the issue with data starting with a number. Here’s the updated code: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, fileId: { type: "string", label: "File ID", }, sheetName: { type: "string", label: "Sheet Name", }, rowData: { type: "string[]", label: "Row Data", }, }, async run({ $ }) { const apiUrl = `https://sheets.googleapis.com/v4/spreadsheets/${this.fileId}/values/${encodeURIComponent(this.sheetName)}:append`; const requestBody = { range: this.sheetName, majorDimension: "ROWS", values: [this.rowData.map((cell) => cell.toString())], }; return await axios($, { method: "POST", url: apiUrl, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, "Content-Type": "application/json", }, data: requestBody, params: { valueInputOption: "RAW", }, }); }, }); In this updated code, I’ve added .toString() to each cell value in the rowData array, ensuring that the entire text is treated as a string and stored correctly. This should resolve the issue with data starting with a number.