How to connect your Custom Counter to Google Sheets via Zapier

Hi there!

If you need to create an integration between Zapier and Google Sheets for your Custom Counter, this article is for you :)

1. To start with, please open the Zapier website. Log in using the most convenient method or click ‘Sign up’ if you do not have an account yet.

2. Once logged in, please click ‘Create’ → Zaps

3. Then, please click on ‘Trigger’ and add ‘Google Sheets’

4. Once you have selected Google Sheets, proceed to choose an event, for example, ‘New or Updated Spreadsheet Row’
5. The next step is to connect your Google Sheets account to the Zap. Please log in and then click ‘Add and continue’

6. Please select the Trigger parameters, such as Spreadsheet, including your preferred Worksheet and Trigger option. Then, click ‘Continue’.

7. Then you can test your Trigger, by clicking ‘Test Trigger’ and the following page will open:

Select the row you want to be displayed on the Counter and click ‘Continue with selected record’

8. Then it will suggest you to search for Action. On this step, please select ‘Smiirl’.

9. The next is to choose an event for Smiirl. For example, ‘Set value’ so that the number on the Counter updates according to the updates of the cell value.

10. Once you have selected your event, you can move on to selecting the Counter and the number to add. Please note that to be visible in the drop-down menu here, the Counter should be set to Push Number option in my.smiirl.com.

11. Once those are selected, you can proceed to test the designed integration by clicking “Test Step”

12. If the displayed results meets your expectations, you can click “Publish”. And that’s all!

If you encounter issues, you can either reach out to a Zapier support team or to our support team via support@smiirl.com and we will be glad to investigate the issue together.