You can check the documentation for the full list of available API requests, but if you just want to jump in, you can play around with the URLs you enter in the API URL path field. A moment later you’ll see Harvest data populate your Google Sheet:
In the Create screen, enter the Request URL we just created:.Open up Google Sheets and click Add-ons > API Connector > Open.Let’s get that Harvest time entry data into Google Sheets. Putting it all together, we get the full API Request URL: Part 4: Pull Harvest API Data into Sheets The ‘page’ parameter is optional but we’ll include it to show how parameters work. Part 3: Create Your Harvest API Request URL Mark this ID down as we’ll need it shortly. Choose an output sheet and click Run and you should see your account ID(s) returned into a sheet, under the field name accounts » id. In API Connector, open up the Create tab and enter the following URL: Therefore, as a precursor to getting data, let’s first find out our account ID. This is actually pretty useful if you’re working with multiple Harvest accounts, since it enables you to differentiate between them. Harvest requires that you pass your account ID into a header when making requests to the API. You’ll then be returned to your Google Sheet, and can verify that your Harvest connection is active in the Connections screen.You will see a modal asking you to approve the connection.In the list of available connections, find Harvest and click Connect.Open up Google Sheets and click Add-ons > API Connector > Manage Connections.If you haven’t connected to the Harvest API before, you’ll first need to initiate the connection.
Appendix: Connect with a Personal Access TokenĬlick here to install the API Connector add-on from the Google Marketplace.Part 4: Pull Harvest API Data into Sheets.Please check the appendix for detailed instructions to retrieve your token. Preset “Connect” button (OAuth) premium.
There are 2 ways to connect to the Harvest API:
In this guide, we’ll walk through how to pull data from the Harvest API directly into Google Sheets, using the API Connector add-on for Sheets.
Import Financial Modeling Prep Data to Google Sheets.Import Facebook Page Data to Google Sheets.Import Facebook Ad Data to Google Sheets.Import CryptoCompare Data to Google Sheets.Import Crunchbase Data to Google Sheets.Import Copper CRM Data to Google Sheets.Import Constant Contact Data to Google Sheets.Import CoinMarketCap Data to Google Sheets.Import CJ Affiliate (Commission Junction) Data to Google Sheets.Import ActiveCampaign Data to Google Sheets.Import AccuWeather Data to Google Sheets.