In this video, we'll learn how to scrape a SERP result, for example, a Google SERP result, using the API from SerpApi into a Google Sheets. Without writing a single line of code!
Full blog version with formulate to copy-paste:
https://serpapi.com/blog/connect-serp-api-with-google-sheet-no-code/
API using:
https://serpapi.com/ register for free
---
Chapters
00:00 Intro and Setup
00:43 About SerpApi and playground
01:06 Search result and JSON response
01:50 Export Sheets formula
02:45 Display a data
04:20 Dynamic value
05:20 Display more data