<?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 Jan Antonin Kolar on Medium]]></title>
        <description><![CDATA[Stories by Jan Antonin Kolar on Medium]]></description>
        <link>https://medium.com/@jakol?source=rss-3d4c293a5a2d------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/2*-quolvFLWqYNpcSiFz91vA.jpeg</url>
            <title>Stories by Jan Antonin Kolar on Medium</title>
            <link>https://medium.com/@jakol?source=rss-3d4c293a5a2d------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 23:06:11 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@jakol/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[Dessert]]></title>
            <link>https://medium.com/@jakol/dessert-e80e186db31?source=rss-3d4c293a5a2d------2</link>
            <guid isPermaLink="false">https://medium.com/p/e80e186db31</guid>
            <dc:creator><![CDATA[Jan Antonin Kolar]]></dc:creator>
            <pubDate>Thu, 07 Apr 2022 09:34:50 GMT</pubDate>
            <atom:updated>2022-04-07T09:34:50.142Z</atom:updated>
            <content:encoded><![CDATA[<iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FMAMUTGwYOcY%3Fstart%3D84%26feature%3Doembed%26start%3D84&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DMAMUTGwYOcY&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FMAMUTGwYOcY%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/b24e35cc3b3798c1f3bce9f16607df4c/href">https://medium.com/media/b24e35cc3b3798c1f3bce9f16607df4c/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e80e186db31" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Make Alexa Read Your Google Analytics Every Morning]]></title>
            <link>https://medium.com/integromat/how-to-make-alexa-read-your-google-analytics-every-morning-52416539cf86?source=rss-3d4c293a5a2d------2</link>
            <guid isPermaLink="false">https://medium.com/p/52416539cf86</guid>
            <category><![CDATA[flash-briefing]]></category>
            <category><![CDATA[alexa-skills]]></category>
            <category><![CDATA[api]]></category>
            <category><![CDATA[integration]]></category>
            <category><![CDATA[workflow-automation]]></category>
            <dc:creator><![CDATA[Jan Antonin Kolar]]></dc:creator>
            <pubDate>Thu, 06 Jun 2019 08:29:02 GMT</pubDate>
            <atom:updated>2019-06-06T08:29:02.575Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*HYsJ77wpwMdf4pEDQxjY2w.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/photos/zfdvBgOjpOs?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Jan Antonin Kolar</a> on <a href="https://unsplash.com/?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>Newsfeed called <strong>the</strong> <strong>flash briefing, </strong>an invaluable feature in the Alexa universe. Unfortunately, it’s still not possible for publishers to customize it to the individual listeners despite being one of<a href="https://alexa.uservoice.com/forums/906892-alexa-skills-developer-voice-and-vote/suggestions/32360281-user-specific-flash-briefing-content"> the most wanted features for months</a>. Thanks to Integromat, an automation tool, there is a way.</p><p>In this tutorial, we will focus on a flash briefing containing data from your Google Analytics. However, the methods introduced in this article are easily applicable to various other data. Using the same method, you could broadcast comments from a Subreddit, RSS entries or data from an API. The possibilities are endless.</p><h3>What We Need</h3><ul><li><a href="https://analytics.google.com/analytics/web/">Google Analytics account</a></li><li><a href="http://integromat.com/">Integromat account </a>(free tier)</li><li><a href="https://dropbox.com/">Dropbox account </a>(ideally a fresh one)</li><li><a href="https://developer.amazon.com/alexa/console/ask">Alexa Developer Console</a> (your Flash briefing will be “In Development”, meaning not public)</li><li>Alexa App (<a href="https://itunes.apple.com/de/app/amazon-alexa/id944011620?mt=8">iOS</a>, <a href="https://play.google.com/store/apps/details?id=com.amazon.dee.app">Android</a>)</li></ul><h3>First Act: Integromat</h3><p>The first task is <strong>to create a structured text file (in </strong><a href="https://developer.amazon.com/docs/flashbriefing/flash-briefing-skill-api-feed-reference.html"><strong>JSON</strong></a><strong> format)</strong> that is regularly uploaded to an accessible public place (a Dropbox account in our case). That is where Alexa will access it and read it for you.</p><p>This task is an ideal case for Integromat. It can connect to your Google Analytics, get the required data about sessions/revenues, etc., save it as a variable and generate a structured text file (JSON) in Dropbox every day without writing a line of code. Let’s start!</p><h4>A New Scenario</h4><ul><li>Log in to your Integromat account and create a new scenario in Integromat with the first module: “<strong>Google Analytics — Get a report”</strong>.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/215/1*64nt4zpM4vY-RX2W9U6X9A.png" /></figure><ul><li>Click on the Analytics module and link Integromat to your Google Analytics under the <strong>“Connection” </strong>option, provide access, select a website, and a required metric that you want Alexa to report. In our case, it is the <strong>number of sessions</strong> from the previous day from the Status Quack webpage, but there are many more metrics to choose from.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/620/1*hzM7-bNTfk1chPpWALT2pw.png" /></figure><ul><li>Notice the attached “clock” icon 🕙. It&#39;s where we set <strong>how often we want to run the scenario</strong>, in other words how often we want to have an updated flash briefing. For our case, we want to set “Run Scenario:” to “Every day” at 6:00 Europe/Zurich. If you are in the Pacific Time zone (-9 hours) and want the same time of update, add nine hours (15:00).</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/523/1*adIJqwNHNwndZCagCbdhmQ.png" /></figure><h4>Building JSON</h4><p>After connecting Google Analytics with Integromat and selecting the metric, we have the data that we want to broadcast. The next step is to put them into an Alexa friendly format. According to <a href="https://developer.amazon.com/docs/flashbriefing/flash-briefing-skill-api-feed-reference.html">the documentation</a>, to create a flash briefing, we need to provide data in JSON format.</p><p>But first, we will need a place within Integromat for this structured text.</p><ul><li>For that, create a new module: <strong>“Tools — Set variable”</strong>.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/527/1*_U8002MN55P6rH9mKiMHpw.png" /></figure><ul><li>Click on the module and feel free to choose any variable name (e.g. jsonData).</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/573/1*-yGtxVyARNLto4VSzSRJJw.png" /></figure><ul><li>Now it&#39;s time to write a structured text into the <strong>“Variable Value ” </strong>field. To make it easier, I prepared a template that you can just paste in.</li></ul><p><strong>A Flash Briefing Template</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/3777b458a5b832833cdfdfc3a6339218/href">https://medium.com/media/3777b458a5b832833cdfdfc3a6339218/href</a></iframe><ul><li>The important part is <strong>“mainText”,</strong> but for a better understanding, I mentioned a few details about each line. Feel free to skip this part.</li></ul><p>— — — You Can Skip This Part — — —</p><p><strong>“uid” </strong>stands for a <a href="https://en.wikipedia.org/wiki/Universally_unique_identifier">universal identifier </a>that helps to identify the data. With every update, we need to generate a new one. It is not grand magic, just a random set of alphanumeric characters. Some services provide <a href="https://www.uuidgenerator.net/api">UIDs for free</a>. For our purposes, we should be fine with only changing the last ten characters with a timestamp variable. Be aware, it&#39;s a quick and dirty solution.</p><p><strong>“updateDate”</strong> is here to indicate the date of creation. Amazon uses the <a href="https://en.wikipedia.org/wiki/ISO_8601">standard date format</a>, as does Integromat, and the date variable is called “now”. Please, bear in mind that the time zone is set by the Integromat server (UTC) and change is possible by changing the attribute “Europe/Zurich” to for example “<a href="http://www.timezoneconverter.com/cgi-bin/zoneinfo">America/New_York</a>”.</p><p><strong>“titleText”</strong> is not very important, Alexa won’t read it, but it will be visible on Echo Show. So for clarity, I inserted a variable with the current date.</p><p>— — — The End of The Part That You Can Skip — — —</p><ul><li><strong>Alexa will read whatever you write</strong> in the quotation after a colon in the <strong>“mainText”</strong> part. Let’s use data from the Google Analytics module.</li><li>Integromat works intuitively, once you start writing you will get suggestions with variables that you can insert into your text. You can see “Session” suggestion in the screenshot.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/923/1*iRnY4BljRdyHS8w5muXMKA.png" /></figure><ul><li>NOTE: The variable with the GA data is not provided in the template, because it depends on your selection.</li></ul><h4>Uploading JSON To Dropbox</h4><p>Once we have the data saved in a variable, it&#39;s time to upload it to Dropbox. For that you need to follow these steps:</p><ul><li>Add a third module called “<strong>Dropbox — Upload a file</strong>”</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/780/1*7DdWG55BStt69PbfYhzeNA.png" /></figure><ul><li>Grant Integromat access to Dropbox by adding a Connection</li><li>Once set, choose a folder (it can be root directory or you can create one)</li><li>In the <strong>“Data”</strong> field pick our JSON variable, in our case “jsonData”</li><li>Choose a file name. (e.g. myFirstBriefing.json)</li><li><strong>IMPORTANT:</strong> under “Show advanced settings” tick the option “Overwrite an existing file”</li></ul><p>In the end, your settings should look like this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/766/1*0Kg0t8k2EdTRfzIiygEWcQ.png" /></figure><p>We created a scenario where you automatically get the data from Google Analytics, generate JSON and save it to Dropbox. Let’s try it, press the button <strong>“▶️ Run once” </strong>in the left bottom corner and see if the “myFirstBriefing.json” file will arrive in your Dropbox. Is it there? It should be.</p><p>To make run your scenario daily, hit the <strong>scheduling</strong> toggle button that is located under <strong>“▶️ Run once”.</strong> Tadaaa, you are all set!</p><h3>Second Act: Dropbox</h3><h4>Making JSON publicly available</h4><p>Uploading the file on Dropbox, fortunately, does not make it a file public. We have to make it accessible manually.</p><ul><li>Go to Dropbox.com, log into your account</li><li>Find your JSON file (“myFirstBriefing.json” in our case)</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/483/1*HADElCadieYiNu4vWqcKzQ.png" /></figure><ul><li>Click on the <strong>“Share”</strong> button next to the file, choose the <strong>“Create link option” </strong>and then <strong>“Copy link”</strong>. It should look like this:</li></ul><blockquote><a href="https://www.dropbox.com/sh/sjhr6ilpvev05cf/AAB44rtVN0yc0Kw2X3gNb02ba?dl=0">https://www.dropbox.com/sh/sjhr6ilpvev05cf/AAB44rtVN0yc0Kw2X3gNb02ba?<strong>dl=0</strong></a></blockquote><ul><li>The last and critical part is to change the parameter <strong>“dl=0”</strong> to <strong>“dl=1”</strong>, in the URL otherwise Amazon won’t be able to read the file!</li></ul><blockquote><a href="https://www.dropbox.com/sh/sjhr6ilpvev05cf/AAB44rtVN0yc0Kw2X3gNb02ba?dl=1">https://www.dropbox.com/sh/sjhr6ilpvev05cf/AAB44rtVN0yc0Kw2X3gNb02ba?<strong>dl=1</strong></a></blockquote><p>Test this by trying to click the link and see if your browser starts to download the file. If that is the case, we can proceed to the final step of our tutorial.</p><h3>Third Act: Amazon Developer Console</h3><h4>Creating your very own flash briefing</h4><p>To create a flash briefing we need an Amazon developer account and be in the Alexa Developer Console. Your content will be available just for you as long as it stays “In development”.</p><ul><li>Log in to your <a href="https://developer.amazon.com/alexa/console/ask">Alexa Developer Console</a></li><li>On the Alexa console select <strong>“Create Skill”</strong></li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/387/1*lrmNsA0lTzPKPcFG-FGa4w.png" /></figure><ul><li>Insert a name and choose <strong>“Flash Briefing”</strong> as the model</li><li>Hit the<strong>“Create skill”</strong> button</li><li>Then click on <strong>“Add new feed”</strong> and fill in the form</li><li><strong>“Preamble”</strong> is something that Alexa will always read before she reads the data. I recommend to fill it with “From Google Analytics”</li><li><strong>“Name”</strong> is really up to you since we will not publish it (e.g., My Daily Analytics)</li><li>Set <strong>“Content update frequency*”</strong> to <strong>“Daily”</strong></li><li>Set <strong>“ Content type”</strong> set to <strong>“text”</strong></li><li>Set <strong>“Content gender”</strong> to anything you want</li><li><strong>Set Feed with the URL from your JSON from Dropbox </strong>(don&#39;t forget, the parameter in the URL has to be changed from “dl=0” to “dl=1”)</li><li>Skip <strong>“Feed icon*” </strong>feed icon</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/698/1*FoaY6WjTgnly5bQS-5cCQQ.png" /><figcaption>A preview of our flash briefing setup</figcaption></figure><ul><li>Hit the <strong>“Add” </strong>button</li><li>Fill the <strong>“Custom Error Message*”</strong> field with text <strong>“Data not available”</strong></li><li>Hit the <strong>“Save” </strong>button</li></ul><p>If you follow the instructions correctly, Amazon will be happy with the JSON structure and availability of the file, and it won&#39;t bother you with an error message.</p><p>Before we leave the Alexa Developer Console, there is one last important step to do, <strong>enabling our flash briefing for testing. </strong>We will do it under the “Test” tab in the menu and change the drop down to <strong>“Development”</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/449/1*wCR4yhYxvpfETp4wHVoUVA.png" /><figcaption>A screenshot from the “Test” tab</figcaption></figure><h3>Fourth Act: Alexa App</h3><p>By enabling skill testing in “Development” we have also subscribed to it, and we are ready to listen. It will be the first one to be played.</p><p>To do so, first, open your Alexa App. Hit the Alexa blue icon in the bottom and say “play news” and listen to your creation. Congratulations 🎉🎉🎉</p><p>Now the gate is open, and you can fully start experimenting with what you want to listen to in the morning.</p><p><em>If you want to see the live action version of this written tutorial, check out this </em><a href="https://youtu.be/Fi1ToNM8pRs"><em>video</em></a><em> that takes you through this build, step by step.</em></p><h4>Note:</h4><p>Uploading files to Dropbox can be theoretically skipped with the use of the Webhook module, in that way Integromat will directly provide you with the URL containing structured text (JSON) for a flash briefing. But there is a problem. Amazon regularly pings the provided URL so you will deplete your operation free tier limit quite quickly.</p><p><strong><em>Try </em></strong><a href="https://www.integromat.com/en/"><strong><em>Integromat</em></strong></a><strong><em> for free today!</em></strong></p><p><strong>Wanting to stay apprised of all updates, integration ideas, and productivity tips? Follow The Integromat Blog, by hitting the follow button below.</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=52416539cf86" width="1" height="1" alt=""><hr><p><a href="https://medium.com/integromat/how-to-make-alexa-read-your-google-analytics-every-morning-52416539cf86">How to Make Alexa Read Your Google Analytics Every Morning</a> was originally published in <a href="https://medium.com/integromat">The Glue of the Internet</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>