I have an API I’m using (SocialBlade). Long story short, I want to be able to pull the information through the API periodically. I have a google sheet which I have a list of social handles and I want to pull the followers for every handle through the API and update either the same sheet or a different sheet. I also want a way to be able to refresh the data every so often. Any ideas?
Question
Custom API request periodically
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+11- Zapier Staff
Hi
It sounds like you should be able to do something like the following:
Trigger: Schedule by Zapier (choose the frequency you’d like)
Action: Google Sheets — Lookup Spreadsheet Rows (output as Line Items)
Here, you would make sure that each row in the sheet contains some value that you’re able to search by, to return all of them.
Action: Looping by Zapier
Use the line items from the Google Sheets step, to loop through each row.
Action: Webhooks by Zapier (to get the data you need)
Action: Google Sheets — Update Spreadsheet Row
Of course, in practice this will be much more involved. I happen to have a free Social Blade account so I was able to find the API documentation.
Here’s the general idea of how to take the cURL command they provide and “translate” that to Webhooks by Zapier:
If this is your first time trying to do something like this, you may want to seek out the assistance of a Certified Zapier Expert :)
The Zappy Awards are back
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.