<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Pablo Uhach on Medium]]></title>
        <description><![CDATA[Stories by Pablo Uhach on Medium]]></description>
        <link>https://medium.com/@made_by_pablo?source=rss-5051cac80d81------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*pO_ivQHbDZcPUgqiNt8bBQ.jpeg</url>
            <title>Stories by Pablo Uhach on Medium</title>
            <link>https://medium.com/@made_by_pablo?source=rss-5051cac80d81------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 03:21:50 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@made_by_pablo/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Researchers: how to automatically pull reviews from AppStore and Google Play]]></title>
            <link>https://uxdesign.cc/how-do-i-automate-getting-reviews-from-appstore-and-google-play-4cc0ebf1a6e4?source=rss-5051cac80d81------2</link>
            <guid isPermaLink="false">https://medium.com/p/4cc0ebf1a6e4</guid>
            <category><![CDATA[design]]></category>
            <category><![CDATA[review]]></category>
            <category><![CDATA[app-store]]></category>
            <category><![CDATA[google-play]]></category>
            <category><![CDATA[appfollow]]></category>
            <dc:creator><![CDATA[Pablo Uhach]]></dc:creator>
            <pubDate>Tue, 05 Oct 2021 07:30:52 GMT</pubDate>
            <atom:updated>2021-10-07T06:40:29.186Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="Table with reviews from Google Play and Appstore" src="https://cdn-images-1.medium.com/max/1024/1*XAeUCOh0eLF7lGTIdA6Q2g.png" /></figure><p>One of the excellent ways to get feedback on developing products is to read the reviews from real people. It’s smooth when you are creating a mobile app. You can go to <a href="https://www.apple.com/app-store/"><strong>App Store</strong></a> or <a href="https://play.google.com/"><strong>Google Play</strong></a> and dive into raw data.</p><h3><strong>Problem</strong></h3><p>It’s convenient and monotonous work for researchers. They have to work out raw data, export it to readable view, prioritize all insights into convenient view to present the team. This process takes a long time from the beginning.</p><h3>Overview</h3><p>First, I had a task to analyze all the reviews and present insights to the product team. I didn’t want to do it all the time, so I found little hacks on how to automate this process.</p><p>To get all the reviews from app stores, I used a service called <a href="https://appfollow.io/"><strong>AppFollow</strong></a>. It helps to monitor mobile app performance (<em>e.g., star rating, position in stores, reviews, etc.</em>). You can export all the reviews in <strong><em>.csv</em></strong> format and import them to Google Sheets. My process looks like this:</p><figure><img alt="Current flow of getting reviews: export reviews, clear raw data, Prioritise reviews, present to the team" src="https://cdn-images-1.medium.com/max/1024/1*8do-8SZJzRXbQc7O9boLTQ.png" /><figcaption>Current flow</figcaption></figure><p>I have to export all the feedbacks, import to Google Sheets, precise raw data (<em>e.g., App Version Name, PS, etc.</em>), categorize by problems, prioritize and present to the product team. By the end of this process, I had one apparent artifact. It’s a presentation with highlighted problems, pains and gains, and sometimes insights from real people.</p><p>To automate this process, I have created in <a href="https://zapier.com/"><strong>Zapier</strong></a> speedy workflow that connects AppFollow with Zapier and exports all reviews into a prepared Google sheets table.</p><figure><img alt="Flow in Zapier" src="https://cdn-images-1.medium.com/max/1024/1*xzS8DUHzPQ9xYw67q9fnPw.png" /><figcaption>Flow in Zapier</figcaption></figure><p>AppFollow exports a lot of irrelevant fields (<em>OS, App Version name, comment from developer, etc.</em>). To avoid this when generating automatization, I selected only the most relevant fields needed in the analysis (<em>rating, date, content, etc.</em>)</p><figure><img alt="Available fields to export from AppFollow" src="https://cdn-images-1.medium.com/max/1024/1*5JjJOHbkNvWsdiPbAv6k_g.png" /><figcaption>Available fields</figcaption></figure><p>To avoid problems with the designing automation in Zapier, I advise you to immediately create a Google Dock with specific fields that you will need. Example of my Google sheet:</p><figure><img alt="Google sheet: Raiting, Title, Date, Content, App Version name, OS, Device, Category" src="https://cdn-images-1.medium.com/max/1024/1*CTtLJt1aD-CFYRCbbOnMkA.png" /><figcaption>Example of my google sheet</figcaption></figure><p>In addition to the automatically exported fields, I created two columns: a column of problems and a column that shows whether the response is processed.<br>The column of problems can be quickly selected from dropdowns, and it is valid for the specific product I am working on. You can have it of your own. <br>At the end of the process, a working doc can be shared with the team or processed, prioritized, and presented to the team.</p><figure><img alt="Updated flow of getting reviews: Prioritise reviews, present to the team" src="https://cdn-images-1.medium.com/max/1024/1*K4-eQVK75ubiE1XV038Qew.png" /><figcaption>Updated workflow</figcaption></figure><h3><strong>Conclusion</strong></h3><p>⚡️ I have automated the process of working with store reviews that increase the speed of the process <strong>by 34%</strong>.</p><p>⚡️ Created sharable doc that any of my team can open and dive into actual data from real users.</p><h3><strong>Templates 💛</strong></h3><p>Template for Zapier (<em>just copy and you have the right zap</em>): <a href="https://zapier.com/shared/c4fd46f77d2c2239c468ee231eef1d061e625c4a">https://zapier.com/shared/c4fd46f77d2c2239c468ee231eef1d061e625c4a</a></p><p>Template for Google sheet: <a href="https://docs.google.com/spreadsheets/d/1ROe7CgFzccs8dz3KVMMCJQlQ5JogB6lALkxP5pDzVd4/edit?usp=sharing">https://docs.google.com/spreadsheets/d/1ROe7CgFzccs8dz3KVMMCJQlQ5JogB6lALkxP5pDzVd4/edit?usp=sharing</a></p><h3>Have questions?</h3><p><a href="https://www.linkedin.com/in/uhach/">https://www.linkedin.com/in/uhach/</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4cc0ebf1a6e4" width="1" height="1" alt=""><hr><p><a href="https://uxdesign.cc/how-do-i-automate-getting-reviews-from-appstore-and-google-play-4cc0ebf1a6e4">Researchers: how to automatically pull reviews from AppStore and Google Play</a> was originally published in <a href="https://uxdesign.cc/">UX Collective</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>