How to Create a New Task in Trello When Your Google Analytics Page View Drops Using Pabbly Connect

Learn how to automate task creation in Trello when Google Analytics page views drop using Pabbly Connect. Step-by-step tutorial included. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect to Set Up Your Workflow

To start automating task creation in Trello when your Google Analytics page views drop, access Pabbly Connect by visiting the Pabbly website. You can create a free account or log in if you already have one. This platform allows you to integrate various applications seamlessly.

Once logged in, you will be directed to the Pabbly Connect dashboard. Here, you can create a new workflow by clicking on the ‘Create Workflow’ button. Name your workflow, for example, ‘Google Analytics to Trello,’ and click on ‘Create’ to proceed. This initiates the setup process where you will configure the trigger and action steps.

2. Setting Up the Trigger in Pabbly Connect

The first step in your automation is to set up a trigger in Pabbly Connect. For this workflow, select the ‘Scheduler’ app as the trigger. This allows you to run the automation daily at a specific time to check your Google Analytics data.

• Choose ‘Every Day’ as the frequency.
• Set the time for execution, for example, 10 AM.

After setting the schedule, click on ‘Save’ to finalize this trigger. This ensures that every day at the specified time, Pabbly Connect will check the analytics data for the previous day and compare it with the day before yesterday.

3. Connecting Google Analytics to Retrieve Data

Next, you will connect to Google Analytics to retrieve the necessary data. In the action step, search for ‘Google Analytics’ and select the ‘Run Report’ action event. Click on ‘Connect’ and authenticate your Google Analytics account. using Pabbly Connect

After connecting, you will need to enter the Property ID of your Google Analytics account. This can be found in the Admin section of Google Analytics. Additionally, specify the start and end dates for the data you want to retrieve, which will be two days ago for one request and yesterday for another.

4. Comparing Yesterday’s Data with Day Before Yesterday

Once you have the data from Google Analytics, you need to compare it to determine if a new task should be created in Trello. In Pabbly Connect, add a filter step to compare the active users and other metrics like bounce rate and conversion rates from both days.

• Set conditions such that if yesterday’s active users are less than the day before yesterday’s, a task will be created.
• Repeat this for bounce rate and conversion metrics.

After setting these conditions, click on ‘Save and Send Test Request’ to ensure that the filter works correctly. If the conditions are met, you can proceed to create a new task in Trello.

5. Creating a New Task in Trello

Finally, set up the action to create a new task in Trello. Search for ‘Trello’ in the action step and choose ‘Create Card’ from the action event options. Connect your Trello account using the API key and token from your Trello account settings. using Pabbly Connect

Once connected, select the board and list where you want to create the card. You can customize the card’s name and description, including the metrics retrieved from Google Analytics. For example, you could name the card ‘Please Check the Analytics of Website’ and include details like active users and bounce rates in the description.

Click on ‘Save and Send Test Request’ to create the card. If successful, a new task will appear in your Trello board, reminding you to check the analytics data.

Conclusion

Using Pabbly Connect, you can automate the process of creating tasks in Trello based on Google Analytics data. This integration allows you to monitor your website’s performance efficiently and take action when necessary. Start using Pabbly Connect today to streamline your workflows and improve productivity.