[SHEETY.CO] How do I get this to work?

Hi,

I’m trying my best to have my datas sent over to Google Sheet using sheety.co services. Does anyone have any clue on how to configure the API CALL using Bubble.io’s API Connector plugin?

I’m getting this error when I try reinitialize call :

There was an issue setting up your call.

Raw response for the API
Status code 500
{
“errors”: [
{
“detail”: “Cannot read property ‘includes’ of undefined”
}
]
}

This is what I tried inputting manually:
{
“Sheet1”: {
“Date”: “11/25/21”,
“Golf Course”: “test”,
“Name”: “test”,
“Group”: “test”,
“Yards”: “1”,
“Hole”: “1”,
“Pars”: “1”,
“Location”: “test”,
“Driver”: “test”,
“Shot”: “1”,
“Finished”: “test”,
“Penalty”: “test”
}
}

hi, see this

and this

and this

@TipLister Thank you so much for the information and guides! Got it to work!

@TipLister yours are the best videos on this topic- thank you! Do you have any experience with posting to multiple unique sheets? I have many users and I want them to post to their own sheets without viewing/overwriting others’. Since Sheety provides a single POST endpoint url for the API Connector, how would one handle multiple, dynamic users?

hi, sorry I dont think thats possible with Sheety. Maybe with the Googlesheets API itself but I dont think so.

Can you not bring the functionality you are trying to handle inside Bubble?
Bubble Databases are kinda like google sheets.

1 Like

Thanks for the reply, @TipLister. My plan was to allow my users to post their data in Bubble to a Google Sheet, then input the Sheet URL in a multiline input and post to Facebook, Twitter, and LinkedIn. Looks like I’ll just have them download a CSV in Bubble and upload it manually to Sheets.

Have a look at pathfix. it seems you are looking to use Zapier to get users to post a Sheet’s rows to a social network when you could just use Bubble with Pathfix to do that, using the OAuth of the social networks, without needing Zapier.
Another approach may be using webhooks on Zapiers which you could perhaps activate using Bubble workflows

Your instincts are correct- on Pathfix and discussing options with their team. Many thanks!

1 Like

Hi,

I am trying to edit a row in my sheet. I have set up as it is explained in the video but get the following answer:
undefined error: this header name is not correct undefined
The GET request is working though.
Would you know what is the issue here please?
Thanks in advance

Hi Rungpattaya
Were you able to get this issue fixed?
As I’m currently going through the same issue in editing a row in my sheet file