Connected Google Sheet no longer works even though the Schema is synced

[Tim Lee]

Hi, 

I've recently been using AA linked with a google sheet as well as Jira Software. It's been working fine until this morning when I synced it. It's started telling me my columns no longer exist and I need to remap them. And then when I click the remap dropdown nothing happens when I select one of tables. Is this a bug? Or can it only handle a certain number of sheets tabs? Any advice on what I can do as I don't really want to have to start again and end up with hours and hours of lost work. 

Whilst new tabs were added to the sheet and picked up, the old ones weren't changed, so I don't know why it no longer recognises the data. 

It also doesn't load my data when I go to create a chart. Nothing happens when I select a table. 

[Tracy Chow]

Hi Tim,

Were the tabs or columns in your Google Sheet renamed at all?

If you can open a ticket with our support team and grant us permission to access your site, we can dig in further to see why your Google Sheet data source is throwing the warnings and see how to get this resolved for you.

Thanks,
Tracy

[Tim Lee]

Hi Tracy, no they weren't, which is why I found it odd. There were new tabs created on the sheet which it picked up but nothing else. I'll raise a ticket, thanks.