Crypto Signals Dashboard

I'm seeking a Python expert with extensive experience in working with both REST and GraphQL APIs. APIs include LunarCrush and DEX Screen and potentially Twitter and pump.fun. The project's primary focus is to ensure real-time synchronization and reporting into Google Sheets and MongoDB. The data will form a Crypto Analytics Dashboard that integrates data from these APIs. The goal is to track promising early-stage cryptocurrencies by analysing social signals and on-chain data. The dashboard will also send Telegram alerts when certain thresholds are met, these thresholds must be editable within Google Sheets so are easily adjusted. A simply task is to be completed before progressing to the dashboard build: 1. Client will supply 50-100 cryptocurrency. All historical data of these cryptocurrency is to be downloaded from LunarCrush using its API. 2. This data will need to be formatted into a Google Sheets for Client to then analyze using a AI tools. The goal is to use this data to analyze which social metrics are the best lead indicators for price. If successful, you will then progress to building the dashboard and the Client will supply a rough dashboard mock-up and required alerts. Key Responsibilities: - Implement integrations with both REST and GraphQL APIs using Python. - Ensure Google Sheets and MongoDB sync in real-time. - Build Google Sheets dashboard with editable input to adjust alert thresholds. - Automate alerts via Telegram. Ideal Skills: - Proficiency in Python. - Experience with REST and GraphQL APIs. - Google Sheets API and MongoDB integration expertise. - Pandas and Webscraping experience. - Knowledgeable in cryptocurrency.. - LunarCrush and DEX Screens experience a bonus. The project will involve pulling live data from API (both REST and GraphQL) then organising the data in google sheets to update every 1 minute. If successful more tasks will follow. To be considered you MUST answer the following: 1. How much experience do you have with REST and GraphQL APIs? Please list some projects. 2. How much experience do you have with Google Sheets? List some projects. 3. Have you used MongoDB before? List some projects. 4. Have you worked with LunarCrush, X (formerly twitter) and DEX Screener APIs? List some projects. 5. Do you have experience working on cryptocurrencies? List some projects. 6. Are you available on a contract basis if you are successful with this task? If you don't answer these questions you will NOT be considered.