Thanks for following up everyone. More information is always helpful in determining the issue. I’ll try and respond to all of you but please let me know if I’ve missed anything.
@kushweez That is interesting. As far as I know, the only reason the request should fail is if our access token for you account is expired or otherwise invalid. There can definitely be other reasons for it to fail, I’m just not aware of them at the moment. I’m a little confused by what you’re saying. Did you add the same Google Sheet as a new data source and it works fine? That seems very odd since there would be no difference in us trying to access the new one vs the old one.
@exploriverse.com I am usually using a Mac on the latest os with the latest chrome (though I’ve also tested safari and firefox in the past). I use google login and generally don’t change the default chrome settings. If you let me know what you’re using that isn’t working I can give that a shot as well.
@pippawilderada Hm that seems like there might be some error on our end when we try to create the data source. I’m guessing our server is having trouble with your sheet for some reason which is why you don’t see any sheets/tables in the second dropdown and why it is unable to sync. If you’re willing to share your sheet that would help us narrow down the issue. If not, can you take a look and see if there is anything you think might cause problems? Could be unusual characters in your sheet names or maybe a unique data layout?
@kushweez Why do you mean by the tables go out of sync for no reason?
@exploriverse.com Yes, Airtable is generally more reliable for us to work with. Google Sheets is a lot more open ended, so that allows for a lot of unexpected behavior and we can’t prepare for all of those issues but we can fix them once we identify them! If you’re willing to share your sheet with me I can take a look. Otherwise, can you see if there is anything you have in that specific sheet which might cause issues?
@drezmaulerkkv Can you let me know specifically how much data (how many rows/columns) you have in your large sheet? I don’t expect that to cause any issues but I can’t know until we test it.