Web scraping with google sheets

Hi, I have a shared worksheet with a few of my friends and we are looking to see if we could pull raw data off the website and into the googlesheet in live time so that we don’t have to manually input it so we can get live info to see if we are winning a fundraising competition.

https://www.firstgiving.com/event/FMAURI/URIGreekWeek2020/teams

The Info I would be looking to pull would be the Team Name, The total QTY of members joined and the total amount of money raised.

I have done some research and I really am looking to see where i should start I have seen that python could be helpful but the way it looked to me was that it would pull info out of the sheet and not into it.

Seems google sheet has an API to write data to google sheets:

https://developers.google.com/sheets/api

which seems to support multiple language including python:

https://developers.google.com/sheets/api/quickstart/python

and python also has scraping libraries. So seems python got you covered :slight_smile:

1 Like