Google Sheets

[pipedream-component-development]

App

Google Sheets

Summary:

Using the sub-agent to create and populate a sheet returns errors

Details:

Using the sub-agent, my OpenAI client submitted the following request:

{
"instruction": "Add 20 rows of random email addresses to the sheet named 'Random Email List' in spreadsheet ID '1XrQz9Qahcq81yljNvxvt_fasiONpe1D7K36gG2zL-Bc'. Use these emails: test1@example.com, test2@example.com, test3@example.com, test4@example.com, test5@example.com, test6@example.com, test7@example.com, test8@example.com, test9@example.com, test10@example.com, example11@email.com, example12@email.com, more13@mail.net, more14@mail.net, person15@mail.org, person16@mail.org, user17@web.com, user18@web.com, fake19@nowhere.com, fake20@nowhere.com. Put 'Email' as the column header in A1."
}

The sub-agent responded:

An error occurred while calling the tool: AI_ToolExecutionError: Error executing tool CONFIGURE_PROPS_GOOGLE_SHEETS-ADD-MULTIPLE-ROWS_PROPS: Cannot read properties of undefined (reading 'id')

The agent then attempted again with this instruction:

Request
{
"instruction": "Add the following 20 email addresses to column A, starting from row 2 (A2), in Sheet1 of spreadsheet ID '1XrQz9Qahcq81yljNvxvt_fasiONpe1D7K36gG2zL-Bc': test1@example.com, test2@example.com, test3@example.com, test4@example.com, test5@example.com, test6@example.com, test7@example.com, test8@example.com, test9@example.com, test10@example.com, example11@email.com, example12@email.com, more13@mail.net, more14@mail.net, person15@mail.org, person16@mail.org, user17@web.com, user18@web.com, fake19@nowhere.com, fake20@nowhere.com."
}

And got this response:

An error occurred while calling the tool: AI_ToolExecutionError: Error executing tool CONFIGURE_PROPS_GOOGLE_SHEETS-ADD-MULTIPLE-ROWS_PROPS: Cannot read properties of undefined (reading 'id')

Finally it tried with this request:

{
"instruction": "Upsert a single row in spreadsheet '1XrQz9Qahcq81yljNvxvt_fasiONpe1D7K36gG2zL-Bc', worksheet 'Sheet1', with value 'test1@example.com' in column A (row 2)."
}

And got this response:

I could not complete the upsert operation because the worksheet ID 'Sheet1' was not recognized correctly, causing an invalid range error.

The spreadsheet '1XrQz9Qahcq81yljNvxvt_fasiONpe1D7K36gG2zL-Bc' is known as "Random Email List."

To proceed, please confirm the exact worksheet name or ID within this spreadsheet. The worksheet ID must match exactly the name of the worksheet.

You can retry with the correct worksheet name or provide the exact worksheet ID for the "Random Email List" spreadsheet.

Screenshots:

[ProdigyMaster]

Same here, bump.
An error occurred while calling the tool: AI_ToolExecutionError: Error executing tool configure_props_google_sheets-add-multiple-rows_props: Cannot read properties of undefined (reading 'id')

[dannyroosevelt]

Hi there, can you confirm the endpoint you're using for Pipedream MCP?