![]() Next to the "Schedule" heading select how often you want ParseHub to run "minute, hour, day, week, month, year". ParseHub will run on that schedule and update your Google Sheet whenever it scrapes new data.Ĥ. All you have to do is set a schedule in your project. You can make the data in your Google Sheet automatically update. Step 3: Schedule your Project to Get Data Consistently Take a look at it for more information. We created this url based on the ParseHub API reference. Replace the API_KEY with the API key from your account. Replace the PROJECT_TOKEN with the actual project token from the "Settings" tab of your project.ĥ. To import a CSV Wide file, you can use the formula below:Ĥ. In the =IMPORTDATA() function create your url like the following for a regular CSV file: Click on the A1 cell and type in =IMPORTDATA()ģ. Step 2: Open Google Sheets and create IMPORTDATA functionĢ. Copy and paste the project token from this tab Go under the "Settings" tab of the projectģ. Open the project that you want to get data from using the APIĢ. Copy and paste the API key that you find on this screenġ. In the ParseHub desktop app, click on "My Account" from the sidebarģ. The API key is located under your account settings.ġ. Step 1: Find your API key & Project Token API key In this example we will get the latest run of data from our events project.Įvery time the project runs and scrapes the website, this Google Sheet will be uploaded with new data. ![]() Instead of downloading data in Excel from the ParseHub extension just one time, we will import the data into Google Sheets.
0 Comments
Leave a Reply. |