Analytics · Claude, ChatGPT or any MCP tool
Track UGC revenue by post in Google Sheets
Put last month’s top-earning posts into a sheet you can sort and share.
Look-only. It changes nothing in Idukki.
The prompt
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.
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 Google Sheets tab with your top posts by attributed revenue, one row per post.
Related workflows
Analytics
Find which social platform’s UGC sells the most
Use Idukki. Get sales analytics by platform for [last quarter]. Rank the sources by revenue. Show add-to-carts and orders next to each. Point out any source with clicks but no orders.
Analytics
Summarize your product ratings by category
Use Idukki. Get my product figures. Show how many products sit at each star rating. List the top categories by product count. Flag products with no category.
Analytics
Send UGC-attributed orders to your own system
A signed webhook for each order your galleries proved or influenced.
Set up inside Idukki. No AI tool needed.
How to set it up : Send UGC-attributed orders to your own system