Skip to main content

I am looking for an example of how to execute an advanced google search /qurey and move the results in to the fields of a google sheet

 

example query - https://www.google.com/search?as_q=coffee+shop+near+me&as_epq=&as_oq=&as_eq=&as_nlo=&as_nhi=&lr=&cr=&as_qdr=all&as_sitesearch=&as_occt=any&as_filetype=&tbs=

 

example result I am looking to have parsed in to a google sheet:

Name, Web address, Headline, physical address, etc.

 

 

 

Hi @MrBrit,

Welcome to the Community! 🎉

I just came across your post here and wanted to check in here to see how you’re getting on. Have you resolved your desired workflow here?

Please do let us know if you’re still in need of some help on this at all - happy to assist further! 🤗


Hello, No I have no resolution to this issue


Hi @MrBrit,

Thanks for letting me know!

You might need to utilize Webhooks by Zapier for this workflow or you can use a Webscraper app. We have a Webscraper Community post here: 

Additionally, Webhooks by Zapier is considered an advanced feature, so our support for it may be more limited. Not because we don't want to help, but because APIs can be tricky to troubleshoot since we can't see what's happening on the other side. Every API that you send a request to is going to have slightly different structures that are required.

This makes it hard for us to know why the request may be receiving errors or not working as expected, beyond taking a general look at what's showing in Zapier.

Here are some resources that may be helpful:

If you are running into feature limitations, you could take a look at our blog post here:

For anything that I may not be able to answer, here are some other options:

Hopefully, this helps.