# How to Automate Google Sheets with Coupler.io Add-on

Learn how to enable automatic data refresh in your data flows using the Google Sheets add-on. If you haven't installed the add-on yet, check out our guide [How to install Coupler.io add-on?](https://docs.coupler.io/addons/google-sheets-addon)

#### YouTube guide <a href="#youtube-guide-w0ybf" id="youtube-guide-w0ybf"></a>

{% embed url="<https://www.youtube.com/watch?v=c08d2j180WU>" %}

#### Set up a data flow. <a href="#set-up-a-data-flow-enh77" id="set-up-a-data-flow-enh77"></a>

{% @arcade/embed flowId="07qGWJhHV8nJQitrXWp2" url="<https://app.arcade.software/share/07qGWJhHV8nJQitrXWp2?ref=share-link>" %}

{% stepper %}
{% step %}
In the toolbar of Google Sheets select "Extensions".
{% endstep %}

{% step %}
At the bottom find the [Coupler.io](http://coupler.io/) extension.
{% endstep %}

{% step %}
Hover over it and select "Launch".
{% endstep %}

{% step %}
From there let it open and select "+ Add data flow".
{% endstep %}

{% step %}
From there, select the "Start with template" option to use one of our many pre-built templates, or select "Start from scratch" to build the connection yourself. You can learn more on how to connect a source and a destination through their dedicated articles.
{% endstep %}

{% step %}
Continue complete the setup of your flow and after completing it select "Save and run".
{% endstep %}
{% endstepper %}

#### Set up the automations <a href="#set-up-the-automations-omm57" id="set-up-the-automations-omm57"></a>

{% @arcade/embed flowId="y8NPLZrbtcX4BZr9RHP7" url="<https://app.arcade.software/share/y8NPLZrbtcX4BZr9RHP7?ref=share-link>" %}

{% stepper %}
{% step %}
Through the Add-On menu open the three-dot menu and select Edit.
{% endstep %}

{% step %}
In the Flow settings section set the frequency to what you want.
{% endstep %}

{% step %}
Click "Save and Close".
{% endstep %}
{% endstepper %}

You can learn how to set up your data flows in the web app in [this article](https://docs.coupler.io/getting-started/how-to-create-your-first-data-flow-with-coupler-io). To find out how to set up automatic data refresh you can refer to [these articles](https://docs.coupler.io/functionality/flow-settings/how-to-set-up-automatic-data-refresh).