Google Sheets Update Issue: Unable to Input Data in Spreadsheet Row | Clay

Google Sheets Update Issue: Unable to Input Data in Spreadsheet Row

Is there an issue with the google sheets update? I'm trying to update a row in a spreadsheet but it's not giving me any place to input the values. It's recognizing the document because it's giving me the different sheets as p=options but when I select on, there's no option to input data. https://app.clay.com/workspaces/149722/tables/t_MX7S27k4cxKK/views/gv_dqGdUMeFfMfx

11 comments

Channeled
APP
·
·
It seems you're having trouble inputting values to update a row in your Google Sheets integration. This issue might be related to the Google account you're using for the integration. To resolve this: 1. Check if you're using the correct Google account for the integration. 2. If you're using the wrong account, try removing the current connection and reconnecting with the correct Google account. The "Lookup, Add, or Update Row" action in Google Sheets should allow you to interact with your spreadsheet, including updating rows. If the issue persists after verifying your account, you may need further assistance. In that case, please request human support by clicking on "Talk to a person" in this chat.
Source: Lookup, Add, or Update Row with Google Sheets
Isaac S.
·
·
No
Isaac S.
·
·
https://app.clay.com/workspaces/149722/tables/t_MX7S27k4cxKK/views/gv_dqGdUMeFfMfx
kushagra
·
·
does the sheet have headers Isaac S. ?
Isaac S.
·
·
🤦‍♂️ there was a hidden top line with no headers. That's why, thank you.
kushagra
·
·
happy to help 🙂, been there done that
1
Isaac S.
·
·
ok, follow-up question now that that's working. Can I do that when the document ID and sheet ID are dynamic variables. The fields in the sheet will be the same every time but the document itself is different. When I pass it the values as a variable, I don't get the dropdown
LuisArturo
·
·
Hey there Isaac thanks for reaching out, sorry for the delay here and appreciate you jumping in Kushagra! To clarify here are you asking whether it possible to have multiple Sheet URL be passed through the integration?
Isaac S.
·
·
Yes, son the table I have document IDs and sheet ids as variables. Basically it's creating an account research sheet for our SDRs. So the format is the same every time because it's automatically created based on a standard template so the fields will be standard every time.
LuisArturo
·
·
Hey there Isaac sorry for the delay here, in this case when using the Google Sheet integrations, the Sheet URL needs to be entered own its own it cannot be withing a column that is inside of the Clay table
Channeled
APP
·
·