Airtable uses Zapier for syncing data between systems, so you should be able to get the same functionality with Zapier's integrations for Sheets: https://zapier.com/apps/google-sheets/integrations/trello.
You also could also set up similar functionality through API Connector, through a series of GET/POST requests that run on a schedule, but as you mention it would require quite a bit of data finagling to get everything in the right format.
u/TLupage This is such a good question! I wish I knew the answer :) So much API documentation is confusing, because they scatter relevant information around (Facebook and Google do this a LOT), or they assume knowledge and skip over key parts. All I can say is that the more you look at it, the easier it gets. Even if they haven't organized their documentation, you will almost always want to know the following, in this basic order:
So, basically I'd suggest just jumping in and trying to read a few well-documented APIs, and then the worse ones will seem more approachable. Stripe is famous for having good documentation, so that's a good one to start with. I've also put a ton of time into reading API documentation and simplifying it in my own API guides. I wrote them for non-developers so I think you could get started with those, too.
Maybe someone else has other ideas. Would you be able to share a link to Zapier's ebook?
This sounds like the kind of thing Zapier is designed for, like to automate linking of separate systems. Maybe their Gmail to Sheets integrations would help? https://zapier.com/apps/gmail/integrations/google-sheets
For some reason Reddit keeps auto-removing my original response to you, maybe from too many links, so I'm trying again with fewer links:
Triggers are managed by Google, so you can view all the triggers running for your account here: https://script.google.com/home/triggers
However, I think it's pretty hard to tell what's what in that view. Therefore, I think a more practical way is to open your Google Drive and click Recent, that way you'll see a list of all your sheets that have recently updated.
One other thing to keep in mind is that Google is aggregating usage across all your scripts and add-ons, as well as certain functions like GOOGLEFINANCE, so it could be affected even if you're not running that many updates via API Connector. If that's the case you could consider running your requests under a different gmail account (I could transfer your account for you to see if that helps).
Finally, we've covered most of it here, but you can see a list of tips for dealing with trigger issues in the docs (check the section in the Scheduling article called "Troubleshooting Triggers").