Help Setup Google Sheets Formula to Scrape Website Data
Budget: $30 – $250 USD
Hi, I'm looking for help setting up a Google Sheets doc to scrape some website data.
Similar setup to the following example - https://www.searchenginejournal.com/google-sheets-for-web-scraping/415140/#close
For my doc I'd like to scrape the following page - https://www.shutterstock.com/search/bear (just as a test)
and for the google sheet to pull 2 columns of all the image titles and urls:
1.
a) various bear silhouettes on the white background
b) https://www.shutterstock.com/image-vector/various-bear-silhouettes-on-white-background-1924530971
2.
a) Bear on white
b) https://www.shutterstock.com/image-photo/bear-on-white-468985424
3.
a) nice to meet you slogan with bear doll illustration on black background
b) https://www.shutterstock.com/image-vector/nice-meet-you-slogan-bear-doll-1841566783
4. etc
5. etc
I've attached a screenshot to show how the first 20 rows should look. I'd like the finished product to automatically pull the desired data for the complete 100 images on that shutterstock page. For the urls, it would also be great if these could include the https:// part so they are clickable links.
Any questions please let me know, thanks.
Similar setup to the following example - https://www.searchenginejournal.com/google-sheets-for-web-scraping/415140/#close
For my doc I'd like to scrape the following page - https://www.shutterstock.com/search/bear (just as a test)
and for the google sheet to pull 2 columns of all the image titles and urls:
1.
a) various bear silhouettes on the white background
b) https://www.shutterstock.com/image-vector/various-bear-silhouettes-on-white-background-1924530971
2.
a) Bear on white
b) https://www.shutterstock.com/image-photo/bear-on-white-468985424
3.
a) nice to meet you slogan with bear doll illustration on black background
b) https://www.shutterstock.com/image-vector/nice-meet-you-slogan-bear-doll-1841566783
4. etc
5. etc
I've attached a screenshot to show how the first 20 rows should look. I'd like the finished product to automatically pull the desired data for the complete 100 images on that shutterstock page. For the urls, it would also be great if these could include the https:// part so they are clickable links.
Any questions please let me know, thanks.