CoinMarketCap is a cryptocurrency data platform that provides real-time and historical cryptocurrency data, including prices, market capitalization, trading volume, and market trends. By connecting CoinMarketCap to Coefficient, you can import this data directly into Google Sheets or Excel for easier reporting and analysis.
Using Coefficient’s AI-powered agent chat, you can retrieve data from CoinMarketCap’s API endpoints and organize it in your spreadsheet. You can also schedule automatic refreshes, capture data snapshots, and set up automations to keep your reports up to date.
Schedule your Import, Snapshots, and Add Automations
FAQs for CoinMarketCap Integration
Connecting to CoinMarketCap
When you begin a CoinMarketCap import for the first time, you will need to go through a few steps to connect to CoinMarketCap as a data source for Coefficient.
|
1. Open the Coefficient Sidebar and click the Menu. |
2. Select “Connected Sources”. |
3. Select “Add Connection” at the bottom and then “Connect” to CoinMarketCap. |
|
4. Generate an API Key from your CoinMarketCap account. ℹ️ NOTE: Sign in to pro.coinmarketcap.com/account (create a free Basic developer account if you do not have one). On your account dashboard, find the API Key section and copy your key. Please see CoinMarketCap API documentation for details. |
5. Paste the API Key generated from your CoinMarketCap account and click Connect. |
6. When successful, you can proceed with creating an import by clicking the "Import data..." button at the bottom.
|
Import from CoinMarketCap
|
1. Open the Coefficient Sidebar and click on the “Import from…” button. |
2. Select “CoinMarketCap” from the list. |
|
3. Enter a clear and specific prompt describing your request for the data you need from CoinMarketCap. |
4. Fields relating to your request will appear in the sidebar for you to select/unselect to include in your import. Click on "Add fields" to show all available fields. Click "Import" to proceed. |
5. Please allow a moment for the agent to generate your import. (The results will appear shortly.) Congratulations on creating your first CoinMarketCap import through the agent chat! 🎉
Schedule your Import, Snapshots, and Add Automations
Once you have pulled your data into your spreadsheet using Coefficient, you can set up the following:
FAQs for CoinMarketCap Integration
How can I update or add filters to refine the data in my CoinMarketCap import?
|
To edit your import, open it from the sidebar and click “Edit import” under the summary section (see screenshot). From there, enter a new prompt in the agent chat describing the updates you’d like to make (such as adding filters or adjusting sorting). |
Can I schedule my import for auto-refresh after it has been created by the agent?
Yes, once your import has been created by the agent, you can schedule it to auto-refresh from the “Refresh Schedule” section in the sidebar.
How can I update the API key for my CoinMarketCap data source connection?
When you edit your import and open the Agent Chat, the AI will automatically detect if your API key is no longer valid. If needed, you’ll be prompted within the chat to update or enter a new API key.
How can I provide feedback about my experience with the agent chat?
|
After your import is created, a prompt will appear in the sidebar allowing you to share your experience with the agent by selecting like or dislike. Your feedback helps us continue to improve the experience. 🙏🏼 |