Setting up Cryptosheets

Prerequisites

Please make sure that you have the following:

1. Treehouse API key

2. Cryptosheets account

Adding Your Treehouse API Key

1. Visit the settings page of the Cryptosheets Web App

2. Click on the "All Integrations" tab

Settings page

3. Search for Treehouse and click "Activate"

All Integrations page

4. Follow the steps and input your Treehouse API access key

5. Once you've successfully activated Treehouse, it should appear under the "Your Integrations" tab

Your Integrations page

Connecting Cryptosheets to Excel / Google Sheets

The next step is to install the add-in on Excel / Google Sheets. To do so, follow this guide by Cryptosheets.

Once successfully installed, you're ready to start building queries on Excel / Google Sheets!

Building Your Queries

1. Head over to the browse section of Cryptosheets and search for Treehouse

2. Select an API that suits your needs

Treehouse APIs on Cryptosheets Web App

3. Build your query on Cryptosheets - you can see the output of your query using the "Make Request" button

4. Once you're satisfied with the output, copy the query and paste it into your Excel / Google Sheet