Google Sheets Monitoring

Name: Google Sheets Monitoring
Author: dtrungtin

by dtrungtin

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

695,013 runs

11 users

Try This Actor

Opens on Apify.com

About Google Sheets Monitoring

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

What does this actor do?

Google Sheets Monitoring is a web scraping and automation tool available on the Apify platform. It's designed to help you extract data and automate tasks efficiently in the cloud.

Key Features

Cloud-based execution - no local setup required
Scalable infrastructure for large-scale operations
API access for integration with your applications
Built-in proxy rotation and anti-blocking measures
Scheduled runs and webhooks for automation

How to Use

Click "Try This Actor" to open it on Apify
Create a free Apify account if you don't have one
Configure the input parameters as needed
Run the actor and download your results

Documentation

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.