In this tutorial, we show you how to extract data from any API using Zapier webhooks and then populate a Google Sheets with that data. The Zapier workflow triggers when a new row (domain) is added to the Google Sheet, retrieves relevant data from the API, and then automatically updates the appropriate row in the Google Sheet with the retrieved data.
⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯
Tool Used: https://zapier.com/
⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯
💥 Join our Community of makers —https://community.nocodedevs.com/home
🚀 Add your tool to our directory & browse 400+ tools — https://www.nocodedevs.com/
✍🏻 Weekly NCD newsletter — https://newsletter.nocodedevs.com/
✅ Merge discord for developers and non-developers – https://bit.ly/3OhPxiz
⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯⎯
00:00 Introduction
00:45 Exploring XylaLabs and Choosing an API
01:23 Testing the API and Gathering Data
03:12 Setting Up Google Sheets and Zapier Workflow
05:07 Configuring Webhooks and API Call
08:32 Updating Google Sheets with API Data
10:40 Finalizing and Testing the Workflow
12:17 Conclusion
How to make API calls in Zapier with Webhooks and API requests [Video]
Categories