Compare iOS and Android review complaints with Apify, OpenAI and Google Sheets
UnknownWhat this workflow does
This AI workflow has 14 nodes and runs on a schedule (every week at 08:00). Along the way it connects OpenAI Chat Model, Google Sheets, Slack and Notion and 1 more.
How it runs
Trigger: On a schedule (every week at 08:00).
- Your two app listings (Edit Fields (Set)): sets 4 fields: appName, playAppId, appStoreId…
- Android reviews (Apify): run actor and get dataset (actors)
- iPhone reviews (Apify): run actor and get dataset (actors)
- Put both stores together (Merge): merges the data from its input branches
- Label each review with its store (Code): runs custom JavaScript code
- Drop the one-liners (Filter): keeps only the items that match a condition
- Skip reviews seen last week (Remove Duplicates): removes duplicate items
- Name the complaint (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model
- Find the gap between the two stores (Code): runs custom JavaScript code
- Write this week table (Google Sheets): append
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Android reviews, iPhone reviews).
Nodes used (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Apify
@apify/n8n-nodes-apify.apify - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Remove Duplicates
n8n-nodes-base.removeDuplicates - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Notion
n8n-nodes-base.notion
From the author
Quick overview This workflow runs every Monday morning to scrape recent reviews for your app from Google Play and the Apple App Store via Apify, uses OpenAI to label each negative review with a short complaint theme, and writes a weekly comparison table to…