Google Sheets Monitoring avatar

Google Sheets Monitoring

Try for free

1 day trial then $50.00/month - No credit card required now

View all Actors
Google Sheets Monitoring

Google Sheets Monitoring

dtrungtin/google-sheets-monitoring
Try for free

1 day trial then $50.00/month - No credit card required now

This actor will monitor the google sheets file and do actions correspondingly.

This actor will monitor the public google sheets file and do actions correspondingly. You should setup the schedules to run this actor periodically.

Included features

  • Crawling webpage - Crawling a web page url and filling the extracted texts into corresponding columns.

How it works

  1. Load the public google sheets file and read the web page url in the column URL.
  2. Crawling the web page using axios + cheerio and extracted texts by CSS selector in the google sheet column headers.
  3. Fill the extracted texts into corresponding columns.
  4. If the new text are different from the old text, fill the new datetime into the column UPDATED.
  5. Store the updated rows in the dataset.

Example

https://docs.google.com/spreadsheets/d/1AzIBAKF-_Bv2XRv1wT8SU9yUozdAYOP2JgTASjK7vXo

example google sheet file

If you'd like ary more features, please email dtrungtin@gmail.com with your request.

Developer
Maintained by Community
Actor metrics
  • 1 monthly user
  • 0 stars
  • 100.0% runs succeeded
  • Created in Aug 2024
  • Modified 23 days ago
Categories