Hey all!
Been pulling my hair out for a while on this one and I’m curious if anyone else has managed to figure this out… Here’s the setup:
• I’ve got a database in Airtable that features a set of YouTube user IDs/handles and an associated subscriber count for each ID.
• I can get current values for subscriber count via Social Blade’s API (webhook)
What I’d like to achieve, but can’t:
• Run a zap every X interval (day or so?) that updates the subscriber count value in Airtable for ALL records in the sheet.
I’ve managed to set up a Zap that will achieve the above, but only for a singular record. The data pipeline seems to work just fine, I just can’t figure out how to get it to loop over some version of this sequence:
1) Grab the youtube handles/IDs from each record in the sheet
2) Run the IDs through Social Blade’s statistics API endpoint (via webhook)
3) Get updated subscriber count values for each handle/ID
4) Update all records in airtable with the fetched/more recent values
If anybody can help a fella out, I’d suuuuper appreciate it! GAH.
