Google Sheets Data Extraction using Apps Script
One-click data extraction from Google Sheets, using Apps Script. Criteria for data extraction is user defined.
Overview
We can extract specific data from google sheets, using Apps Script.
We use a simple button, which can also be set in the Menu, which runs the extraction script. This script filters the data using our criteria and pastes the result into a new sheet. Using 1-click button, we can extract data from google sheets using any criteria.
Demo (Video)
Google Sheets Interface
The Google sheet interface allows users to define their extraction criteria and click a button for extraction to occur to a new sheet.
Below is the extracted data
Google Apps Script Logic
The Apps Script:
- Fetches the Google Sheet, the source and destination sheets
- Gets the user input for setting the criteria
- Filters the source data based on criteria
- Pastes the filtered results into the destination sheet
- This Script is linked to a button in Google Sheets, and runs when the button is clicked
Tech Stack
- EGoogle Sheets for storing the source data, extracted data and button
- Google Apps Script for automating the extraction process
Key Learnings
- Fetching Google Sheets by their unique ID and all the sheets within that workbook
- Filtering a table and retrieving filtered data
- Linking a button to an Apps Script