Data extraction templates for a browser agent

• Turn a list on a website into a sheet

  Each item from each page, one row for each, with no duplicates.

  You start it: When you start it

  • Any website
  • Google Sheets

• List local businesses with their contacts

  Name, address, phone, website, rating and e-mail for each business.

  You start it: When you start it

  • Google Maps
  • Google Sheets

• Fill in each new row of a sheet

  The missing fields from official sources, with a source link for each value.

  On an event: When a row is added to the sheet

  • Google Sheets

• Export your order history

  For stores with no export: each order in a sheet, with totals for each year.

  You start it: When you start it

  • Any online store
  • Google Sheets

• Pull tables from PDFs into a spreadsheet

  Each matching table from your PDFs and scans in one sheet, with numbers as numbers and the page noted.

  You start it: When you start it

  • Google Drive
  • Google Sheets

• Clean up a messy spreadsheet

  Consistent names, dates, phone numbers and amounts in a new tab, with a count of each type of change.

  You start it: When you start it

  • Google Sheets

• Find and merge duplicate rows in a sheet

  Exact and near-duplicate rows grouped and merged into one row each, with a list of every merge.

  You start it: When you start it

  • Google Sheets

• Copy numbers from your dashboards into a sheet

  One new row each week with the numbers from each of your dashboards, ready for charts.

  On a schedule: Every Monday at 7:00

  • Stripe
  • Google Analytics
  • Any admin panel
  • +1 more: Google Sheets

• Build one table from several public statistics

  Numbers from official sources in one sheet, with the same units, years and country codes.

  You start it: When you start it

  • OOur World in Data
  • Any government site
  • Google Sheets

• Prepare a CSV for import into another tool

  Your data mapped to the import template of the target tool, checked against its rules, saved as a CSV.

  You start it: When you start it

  • Google Sheets
  • Any admin panel

• Check and complete business addresses in a sheet

  Each business address checked on the map, with the postcode, the coordinates and a status for each row.

  You start it: When you start it

  • Google Maps
  • Google Sheets

• Check which websites in a list still work

  Each website marked live, redirected, parked or dead, with the final address and the date of the check.

  You start it: When you start it

  • Google Sheets
  • Any website

• Extract study results into a table

  Design, sample size, outcome and effect size with confidence interval from each paper, in one sheet.

  You start it: When you start it

  • PubMed
  • Google Scholar
  • Google Sheets

• Asks first

  Move a spreadsheet into Notion or Airtable

  Your rows in a new database with the right field types, checked against the sheet after the import.

  You start it: When you start it

  • Google Sheets
  • Notion
  • Airtable

• Asks first

  Request a copy of your data from your accounts

  A data download requested in each account, with what each export includes and when it is ready.

  You start it: When you start it

  • Any website
  • Google Drive

• Export your product reviews into a sheet

  Each review of your product with date, rating, text and theme, plus counts and averages for each theme.

  You start it: When you start it

  • App Store
  • Google Play
  • AAmazon
  • +1 more: Google Sheets

• Check companies in the official register

  Legal name, number, status and VAT validity for each company in your list, from official sources.

  You start it: When you start it

  • Any government site
  • Google Sheets

• Group open survey answers into themes

  Each open answer tagged with themes, with counts, shares, example answers and a short summary.

  You start it: When you start it

  • Google Forms
  • Google Sheets

• Compare two lists and find the differences

  Rows in only one list, and rows in both with different values, side by side in one sheet.

  You start it: When you start it

  • Google Sheets
  • MMicrosoft Excel

• Count hours for each client from your calendar

  Every meeting matched to a client, with total hours for each client and each week, in a sheet.

  You start it: When you start it

  • Google Calendar
  • Google Sheets

• Export all your Search Console data to a sheet

  All queries and pages for a date range, past the 1,000-row export limit, combined in one sheet.

  You start it: When you start it

  • Google Search Console
  • Google Sheets

• Combine many CSV files into one sheet

  All files from a folder in one table, with the columns lined up and the source file on each row.

  You start it: When you start it

  • Google Drive
  • Google Sheets
  • Dropbox

• List every page of a website in a sheet

  Each page with its title, description, H1, word count and last update, from the sitemap.

  You start it: When you start it

  • Any website
  • Google Sheets

• Collect stats for a list of GitHub repositories

  Stars, last release, last commit, license, issues and downloads for each repository, in your sheet.

  You start it: When you start it

  • GitHub
  • npm
  • PyPI
  • +1 more: Google Sheets

• Find errors and outliers in a spreadsheet

  Impossible values, outliers, broken formulas and mixed units, listed by cell with a suggested fix.

  You start it: When you start it

  • Google Sheets
  • MMicrosoft Excel

• Find the customs tariff code for each product

  The HS and tariff code for each product, with the duty rate and the official source, in your sheet.

  You start it: When you start it

  • Any government site
  • Google Sheets

No template matches. Clear a filter, or write your own task in the Cuiar side panel.