This workflow automatically fetches reviews for one or more Google Play Store apps, summarizes the feedback using OpenAI, stores and manages review data with Pinecone, and posts the summary to a Slack channel. It is designed for product teams, community managers, or anyone who wants to keep track of app sentiment and review trends without manually reading each review.
Features:
- Fetches daily reviews for specified Google Play Store app bundle IDs using a Google Service Account.
- Stores reviews in a Pinecone vector database for efficient retrieval and summarization.
- Uses OpenAI to generate a summary, including:
- Positive and negative review highlights
- Star rating breakdown and average rating
- Total number of reviews processed
- Posts the summary to a Slack channel of your choice.
- Supports both daily and weekly triggers.
- Automatically clears old reviews from the vector store weekly to keep data fresh.
Setup Instructions:
- Add your Google Play app bundle IDs in the “Set the bundle ids” node.
- Configure your Google Service Account, Pinecone, OpenAI, and Slack credentials.
- Set your preferred Slack channel in the “Send to Slack channel” node.
- Enable the workflow and customize the schedule as needed.
Use Cases:
- Monitor app sentiment and user feedback trends.
- Share review insights with your team in Slack.
- Automate reporting for product or support teams.