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.