Export to Google Sheet Automation is perfect.... except..
I've been working on an automation that cycles through 4 specific sheets in 3 different apps, gets the data from every table on the sheet (about 4-5 straight tables per sheet), and exports it to a Google Spreadsheet (where each table title becomes the sheet title, the column names are extracted for row headers, etc.).
It is working nearly perfectly; it runs in under 5 minutes every time and exports all data perfectly
Except the data for one column called 'CurrentCoach' in one specific app never gets grabbed, all the CurrentCoach rows are just empty! The weird thing is that the column name gets pulled correctly, but never any data, and the column name is what is used to get the data (something like { $.(straight table data)["{ $.(column name) }"] }. It works for literally every other column name across all the apps, but this one is simply not working. I'm truly at my wits' end and have tried everything I can think of to fix it!
Has anyone had this issue before and knows what caused it? Can you take a look at my automation and see what's going wrong?
