One of the beautiful things about Import.io is the ability to automate and schedule your data extractions (commonly known as web scraping). For instance, several of our customers need to extract data daily from different rental listing sites or retail websites to find who and what to target in their own marketing efforts. Command line scripts can automate this task, making it easy to get the data. For those who need the data, but may not know how to build a command line script – Import.io to the rescue!
We built a script for this use case and we want to share it with you. Our script allows a customer to pull URLs from a Google Sheet and feed them into an extractor. The script is implemented using Python, which is a common tool for building and sharing scripts. Customers only need to follow the instructions here.
The script automates the following steps:
- Copies URLs from Google Sheets to a designated extractor
- Initiates an Extractor run
- Provides status of the Extractor run
- Displays the list of URLs in the Extractor
- Performs the extraction of specific data from each URL
- Displays the extracted data in a Google Sheet
This is a common use cases that Import.io solves for customers. For a complete technical description, check out the README. You don’t need an IT pro to automate web scraping. Import.io can help with automation.
Turn the web into data for free
Create your own datasets in minutes, no coding required
Powerful data extraction platform
Point and click interface
Export your data in any format
Unlimited queries and APIs