google sheet integration error - Failed The main function of the Actor threw an exception.
🖥️Platform
2026-09-02T13:54:29.613Z INFO Data processed...
2026-09-02T13:54:29.613Z INFO
2026-09-02T13:54:29.614Z PHASE - UPLOADING TO SPREADSHEET
2026-09-02T13:54:29.614Z
2026-09-02T13:54:29.614Z Total rows: 3, total columns: 13 total cells: 39
2026-09-02T13:54:29.615Z Inserting new cells
2026-09-02T13:54:29.763Z ERROR Request Inserting new rows failed with error Requested writing within range [Sheet1!A40:J1000], but tried writing to column [K]
2026-09-02T13:54:29.764Z ERROR Requested writing within range [Sheet1!A40:J1000], but tried writing to column [K]
2026-09-02T13:54:29.764Z Requested writing within range [Sheet1!A40:J1000], but tried writing to column [K]
2026-09-02T13:54:29.765Z at Gaxios._request (/usr/src/app/node_modules/google-auth-library/node_modules/gaxios/build/src/gaxios.js:142:23)
2026-09-02T13:54:29.765Z at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
2026-09-02T13:54:29.765Z at async OAuth2Client.requestAsync (/usr/src/app/node_modules/google-auth-library/build/src/auth/oauth2client.js:429:18)
2026-09-02T13:54:29.766Z at async exports.retryingRequest (/usr/src/app/src/utils.js:94:24)
2026-09-02T13:54:29.779Z at async module.exports (/usr/src/app/src/upload.js:20:9)
2026-09-02T13:54:29.780Z at async /usr/src/app/src/main.js:212:9
2026-09-02T13:54:29.780Z at async /usr/src/app/node_modules/apify/actor.js:167:23
2026-09-02T13:54:29.613Z INFO
2026-09-02T13:54:29.614Z PHASE - UPLOADING TO SPREADSHEET
2026-09-02T13:54:29.614Z
2026-09-02T13:54:29.614Z Total rows: 3, total columns: 13 total cells: 39
2026-09-02T13:54:29.615Z Inserting new cells
2026-09-02T13:54:29.763Z ERROR Request Inserting new rows failed with error Requested writing within range [Sheet1!A40:J1000], but tried writing to column [K]
2026-09-02T13:54:29.764Z ERROR Requested writing within range [Sheet1!A40:J1000], but tried writing to column [K]
2026-09-02T13:54:29.764Z Requested writing within range [Sheet1!A40:J1000], but tried writing to column [K]
2026-09-02T13:54:29.765Z at Gaxios._request (/usr/src/app/node_modules/google-auth-library/node_modules/gaxios/build/src/gaxios.js:142:23)
2026-09-02T13:54:29.765Z at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
2026-09-02T13:54:29.765Z at async OAuth2Client.requestAsync (/usr/src/app/node_modules/google-auth-library/build/src/auth/oauth2client.js:429:18)
2026-09-02T13:54:29.766Z at async exports.retryingRequest (/usr/src/app/src/utils.js:94:24)
2026-09-02T13:54:29.779Z at async module.exports (/usr/src/app/src/upload.js:20:9)
2026-09-02T13:54:29.780Z at async /usr/src/app/src/main.js:212:9
2026-09-02T13:54:29.780Z at async /usr/src/app/node_modules/apify/actor.js:167:23
