Reporting · Claude, ChatGPT or any MCP tool
Chart daily UGC revenue in Google Sheets
Log revenue and orders from your galleries day by day, ready to chart.
Look-only. It changes nothing in Idukki.
The prompt
Use Idukki. Get my daily sales history from [start date] to [end date]. Then use Google Sheets. Write one row per day: date, add-to-carts, orders, revenue. Add a line chart of revenue.
Idukki does the Idukki part. Your own Google Sheets connector in Claude or ChatGPT does the rest.
How to run it
Add Idukki as a custom connector in Claude or ChatGPT. Paste https://api.idukki.io/mcp and sign in.
Add your own Google Sheets connector to the same assistant.
Paste the prompt. Swap each part in [brackets] for your own details.
New to the connector? The server link is https://api.idukki.io/mcp. See the setup card.
What you get back
A sheet with one row per day and a revenue chart.
Related workflows
Analytics
Track UGC revenue by post in Google Sheets
Use Idukki. Get sales analytics by post for [last month], top 25. Then use Google Sheets. Add a tab named [UGC revenue by post]. Columns: post id, post link, add-to-carts, orders, revenue.
Reporting
Send a weekly UGC report to Slack
Use Idukki. Get my posts from the last 7 days and my top posts. Get my sales analytics overview for the same week. Write a short report with three numbers and three post links. Then use Slack to post it in [#marketing].
G
Reporting
Build a monthly UGC report deck in Gamma
Use Idukki. Get my daily sales history and engagement overview for [October]. Get my top posts. Then use Gamma to make a 6-slide deck. Cover revenue, clicks, top posts, top products and next month’s focus.