How to Get Social Media Weekly Stats on WhatsApp using Pabbly Connect

Learn how to automate weekly social media stats delivery to WhatsApp using Pabbly Connect and Social Blade. Follow this detailed tutorial for setup. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Automation

To get started with automating your social media stats delivery to WhatsApp, first, access Pabbly Connect. This platform is crucial for integrating different applications like Social Blade and WhatsApp. Begin by signing up for a free account on the Pabbly Connect website.

Once registered, log in to your Pabbly Connect dashboard. Here, you will click on the ‘Create Workflow’ button to initiate the automation process. Name your workflow something descriptive, like ‘Social Media Stats on WhatsApp’. This will help you easily identify your automation later.

2. Scheduling the Workflow with Pabbly Connect

In this step, you will set up a schedule to run your workflow automatically. Use the built-in scheduler feature of Pabbly Connect to run your workflow weekly. Select the day of the week you want the stats to be sent, for example, Sunday at 7 PM.

• Choose the ‘Scheduler’ option in Pabbly Connect.
• Select the day of the week (e.g., Sunday).
• Set the time for the workflow to run (e.g., 7 PM).

After configuring these settings, click ‘Save’. Your workflow is now set to collect social media statistics automatically every week at the specified time.

3. Integrating Social Blade with Pabbly Connect

Next, you will connect the Pabbly Connect workflow to Social Blade, which is the analytics tool that will gather your social media stats. In the actions section, search for Social Blade and select the ‘Get Statistics’ action event.

To connect, you will need to provide your Social Blade client ID and access token. Log into your Social Blade account to retrieve these credentials. Once you have them, paste them into the appropriate fields in Pabbly Connect.

• Use the ‘Add New Connection’ option to input your credentials.
• Select the social media platform (e.g., Twitter, Instagram, Facebook) for which you want to collect stats.
• Enter the account name to retrieve the statistics.

After saving your connection, you will be able to fetch the statistics for the selected platform automatically.

4. Generating a Report Using Google Docs

Once the statistics are collected, the next step is to generate a report using Google Docs through Pabbly Connect. Add a new action step to your workflow and select Google Docs, then choose the ‘Create Document from Template’ action event.

Connect your Google account to Pabbly Connect and select the document template you have prepared for your report. This template should include placeholders for the statistics you want to include, such as likes and followers.

Choose the correct template for your report. Map the statistics data from Social Blade into the appropriate placeholders. Save and send a test request to generate the report.

Once the report is generated, it will be stored in your Google Drive, ready for sharing.

5. Sending the Report to WhatsApp

Finally, to deliver the report to WhatsApp, you will need to use the WhatsApp Cloud API integrated with Pabbly Connect. Add another action step and select WhatsApp Cloud API, then choose ‘Send Template Message’ as the action event.

Connect your WhatsApp account and fill in the required fields, including the recipient’s number and the shareable link to the report generated in Google Docs. Ensure you format the phone number correctly, including the country code.

Select the message template you created for sending reports. Map the shareable link of the report to the message. Send a test message to verify the setup.

Once everything is set up correctly, your weekly social media stats will be delivered automatically to your WhatsApp every week.

Conclusion

In this tutorial, we explored how to automate the process of getting weekly social media stats on WhatsApp using Pabbly Connect and Social Blade. By following the steps outlined, you can ensure that your social media performance is tracked and reported seamlessly every week.

Using Pabbly Connect allows you to integrate multiple applications without any coding, making it a powerful tool for automating your workflows.