🚀 Try these playbooks: 1. Scrape Google Maps and Save to Sheets: s.bardeen.ai/3PCe8hP 2. Get reviews from Google Maps and add to Sheets: s.bardeen.ai/3Q0lpta 🔻 Download Bardeen: s.bardeen.ai/Download
A few things to remember when using GPT for Sheets - if you refresh your sheet and you have a formula written across multiple rows the function will make another call to GPT and charge your open AI account again . this can happen if you have an #error in the cell or if you delete cells that you already made an API call to and then execute the formula again. I made this mistake by simply loading up a google sheet that had a column with around 100 rows to fill using a GPT function. I did nothing else but load up the sheet and it continually made API calls to open AI and used up my balance. it was replacing the rows with another API call each time. it was customizing an email to LinkedIn prospects as seen on one of your videos.
NO big deal though , that is why open AI has you set your balance so you don't start bleeding money. Overall , Bardeen is an incredible tool that I use every day. It has unlimited use cases and I can't believe these videos get so few views. I'm a bIg fan of the product , I cant wait for future innovations !
@@trafficante78 not 100% sure if I understood your concern correctly, but what I usually do in these cases is copy / paste values, which replaces the API calling formula with just value. Of course this assumes, you have a value and you have stored your API call formula somewhere in case you re-use it.
Using Bardeen and Google maps, is there a way to view results of venues within a specific radius of one Zip code? Also, can you view the email/contact detail of each venue within that radius?
The contact info can be scraped as long as it's visible on the pages. Regarding narrowing down a search to a specific radius, it doesn't seem to work by zip code (unless you type it in the search bar). Instead, it works by longitude like this: share.cleanshot.com/D9s8zgwQ
Can we scrape phone number from the Google map but for you it is showing error, what we can do to get the phone number because it is very important to contact them
When try to use that it doesn't work. (Your last command returned no results) I even tried in the safeway page in the "example URL" section. When I try in other locations it also gives me the message "The scraper model you're executing is not designed for the "www.google.com.br/maps/place/"my search"" page.
🚀 Try these playbooks:
1. Scrape Google Maps and Save to Sheets: s.bardeen.ai/3PCe8hP
2. Get reviews from Google Maps and add to Sheets: s.bardeen.ai/3Q0lpta
🔻 Download Bardeen: s.bardeen.ai/Download
A few things to remember when using GPT for Sheets - if you refresh your sheet and you have a formula written across multiple rows the function will make another call to GPT and charge your open AI account again . this can happen if you have an #error in the cell or if you delete cells that you already made an API call to and then execute the formula again. I made this mistake by simply loading up a google sheet that had a column with around 100 rows to fill using a GPT function. I did nothing else but load up the sheet and it continually made API calls to open AI and used up my balance. it was replacing the rows with another API call each time. it was customizing an email to LinkedIn prospects as seen on one of your videos.
NO big deal though , that is why open AI has you set your balance so you don't start bleeding money. Overall , Bardeen is an incredible tool that I use every day. It has unlimited use cases and I can't believe these videos get so few views. I'm a bIg fan of the product , I cant wait for future innovations !
@@trafficante78 not 100% sure if I understood your concern correctly, but what I usually do in these cases is copy / paste values, which replaces the API calling formula with just value. Of course this assumes, you have a value and you have stored your API call formula somewhere in case you re-use it.
Can you also link this to Microsoft Excel? This way we can run large data analysis with Power Bi etc…
Using Bardeen and Google maps, is there a way to view results of venues within a specific radius of one Zip code? Also, can you view the email/contact detail of each venue within that radius?
The contact info can be scraped as long as it's visible on the pages.
Regarding narrowing down a search to a specific radius, it doesn't seem to work by zip code (unless you type it in the search bar).
Instead, it works by longitude like this:
share.cleanshot.com/D9s8zgwQ
Can we scrape phone number from the Google map but for you it is showing error, what we can do to get the phone number because it is very important to contact them
There is the phone number higher, but on sheets when you do a “+” first instead of “=“ there is an error
Why is it showing an Error for phone numbers? I need the phone numbers for the lists being scraped.
Great question. The phone numbers start with +.
And Google Sheets treats those as formulas. But the data is in there :)
When try to use that it doesn't work. (Your last command returned no results) I even tried in the safeway page in the "example URL" section. When I try in other locations it also gives me the message "The scraper model you're executing is not designed for the "www.google.com.br/maps/place/"my search"" page.