Google Sheets: Advanced scraping using coding

  • Event: 2018 CAR Conference
  • Speaker: Samantha Sunne of independent journalist
  • Date/Time: Thursday, Mar. 8 at 11:30am
  • Location: Indiana/Iowa
  • Audio file: No audio file available.

Earlier, we scraped data with Google Sheets using formulas and some fancy copying and pasting. This time, we're building more flexible and powerful scrapers by actually writing code inside a Google Sheet. We'll use Google Apps Script, similar to JavaScript, to scrape data into Sheets to make it ready to be shared and analyzed.

This session is good for: Reporters who need techniques to scrape more difficult sites.

Speaker Bios

  • Samantha Sunne is a freelance journalist based in New Orleans, Louisiana. She is the recipient of three national grants for investigative reporting and a frequent speaker at conferences, universities and newsrooms around the world, teaching digital tools and tech literacy for journalists. @samanthasunne

Related Tipsheets

No tipsheets have yet been uploaded for this event.