Go to example tasks
Filter Google Sheet rows with a SQL-like query
Created by
Blackcube
Runs a select/where/order/limit query on Google's side so filtered-out rows are never delivered and never billed.
Google Sheets Scraper API - Sheet to JSON, No OAuthvonsensey/google-sheets-scraper-api
Type
Spreadsheet
Title
Tab
+4 fieldsTextNumberBooleanListObject
Input
Sheet URL:https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit?usp=sharing
Query (SQL-like):select A, C, E where C = 'Male' order by A limit 20
Output fields
Type
Spreadsheet
Title
Tab
gid
Row
Change
Cells
Sign up on Apify01
Create your Apify account to access the Google Sheets Scraper API - Sheet to JSON, No OAuth.
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
