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 speaks at conferences, universities and newsrooms around the world, teaching digital tools and tech literacy for journalists. Her work has been published by the Washington Post, NPR and Reuters, and recommended by the Poynter Institute and the Harvard Shorenstein Center on Media, Politics and Public Policy. @samanthasunne

Related Tipsheets

No tipsheets have yet been uploaded for this event.