
<p>Whatsapp has by far the highest read ratio amongst email, Slack and other communication channels. Which makes it a great way to communicate with your customers 1 on 1.</p>
<p>Today we are introducing a super easy way of scheduling messages to be sent out to from your Whatsapp account.</p>
<p>Please follow the <a href="/posts/how-to-link-your-whatsapp-with-supergroup">Link your Whatsapp with SuperGroup</a> article to setup your account. We're going to use your linked Whatsapp account for sending scheduled messages.</p>
<hr>
<h3>Step 1. Make a copy of the Google sheet template</h3>
<p>
  You can find <a href="https://docs.google.com/spreadsheets/d/1P_skqOT6rEFOE_l9rwB0510mxROkDchXJmUa6oqJT6w/edit?usp=sharing">google sheet template here</a>:
  
  <img src="https://storage.googleapis.com/supergroup-images-2/1681097607-sg-scheduler-1.png" alt="Make a copy of this Google sheet" style="max-width: 100%;">
</p>
<p>Make a copy of <a href="https://docs.google.com/spreadsheets/d/1P_skqOT6rEFOE_l9rwB0510mxROkDchXJmUa6oqJT6w/edit?usp=sharing">the Google sheet</a> in your account so you can edit it.</p>
<h3>Step 2. Update the SG_Scheduler sheet with your messages</h3>
<img src="https://storage.googleapis.com/supergroup-images-2/1681097608-sg-scheduler-2.png" alt="Update the SG_Scheduler sheet" style="max-width: 100%;">
<p>The messages you wish to send can be configured in the <strong>SG_Scheduler</strong> sheet. Let's go through the columns:</p>
<ul>
  <li>
    <p><strong>Should_send</strong>: This is a dropdown to help you quickly enable / disable messages to be sent. As you must have figured out already, <strong>yes</strong> means the message should be sent. <strong>no</strong> means it should not.</p>
  </li>
  <li>
    <p><strong>Sender_number</strong>: This is the sender account in case you have linked multiple Whatsapp accounts with SuperGroup. In case you only have 1 Whatsapp account linked, you can leave this blank.</p>
  </li>
  <li>
    <p><strong>Send_to</strong>: You can specify the id of the user / group you want to send the message to. This is the numeric id you see on the SuperGroup dashboard page, or else you can specify the user name / group name. When specifying names, ensure that the name matches exactly. In case of a typo, no messages will be sent (we err on the side of caution). You can specify multiple recipients here, each on a new line.</p>
  </li>
  <li>
    <p><strong>Message_type</strong>: We support <code>text</code>, <code>image</code>, <code>video</code>, <code>document</code> and <code>poll</code>. Select the appropriate message type from the dropdown. To send an image or a video, upload the file to a Google drive folder and share it with <a href="google-sheets-updater@oauth-app-368203.iam.gserviceaccount.com">SuperGroup service account</a>. Then you can add the link to the Google drive file in the text message and watch it go. See the section on <strong>Sending media</strong> below for more details.</p>
  </li>
  <li>
    <p><strong>Message</strong>: Type the message you wish to send here.</p>
  </li>
</ul>
<p><strong>Time columns</strong></p>
<p>The days columns below indicate the day of the week to send the message on. Put the time you want to send the message out in <code>hour:mins AM|PM</code> format, like <code>9:00 am</code> or <code>2:30 pm</code>.</p>
<ul>
  <li><strong>Sun</strong></li>
  <li><strong>Mon</strong></li>
  <li><strong>Tue</strong></li>
  <li><strong>Wed</strong></li>
  <li><strong>Thu</strong></li>
  <li><strong>Fri</strong></li>
  <li><strong>Sat</strong></li>
</ul>
<h3>Step 3. Share the sheet with SuperGroup</h3>
<p>Share your new google sheet with <strong>google-sheets-updater@oauth-app-368203.iam.gserviceaccount.com</strong> with editor access. This gives SuperGroup the access to read and write to this sheet.</p>
<h3>Step 4.</h3>
<p>
  Copy the google sheet url and paste it in the <strong>Integrations</strong> section on your SuperGroup dashboard.
  
  <img src="https://storage.googleapis.com/supergroup-images-2/1681118505-add-integration.jpg" alt="Add integration" style="max-width: 400px;">
</p>
<p>Once added, you should see the sheet id as active. You can pause or delete the scheduler if required.</p>
<p>Your scheduled messages should now go as planned. Do keep a buffer of +-5 minutes for your messages.</p>
<h2>Sending media</h2>
<p>SuperGroup supports sending polls, text, image, video messages and documents. Select the appropriate message type you wish to send. To send an image or a video:</p>
<ol>
  <li>Upload the file to a Google drive folder</li>
  <li>Share the folder with the <a href="google-sheets-updater@oauth-app-368203.iam.gserviceaccount.com">SuperGroup service account</a></li>
  <li>Now add the link to the Google drive file in the text message, like this:</li>
</ol>
<img src="https://storage.googleapis.com/supergroup-images-2/1688528774-supergroup-send-image.png" alt="Send media messages" style="max-width: 100%;">
<p>SuperGroup automatically downloads the file and sends the appropriate message.</p>
<p>NOTE: Don't forget to give permissions to the service account mentioned above, otherwise the message cannot be sent.</p>
<h2>And you're all set 🚀</h2>
<hr>
<h2>Try SuperGroup now</h2>
<p>
  Wanna supercharge your Whatsapp &#x26; communities ?
  <a href="/#contactus">Try SuperGroup now</a>
</p>


Send scheduled messages using SuperGroup


<p>For small businesses when starting out, its super important to stay lean and validate your hypothesis as quickly as possible. This is only possible if you are churning out ideas and concepts quickly, and putting them in front of the user and gauging their response.</p>
<p>This calls for a light weight frontend and backend layer. While there are tons of technologies out there for fast frontend development (like Nextjs, React, Svelte etc.), recently people have started realizing the value of having a simple drag and drop widget like dashboard builders like <a href="https://www.appsmith.com/">Appsmith</a>, <a href="https://retool.com/">Retool</a>, <a href="https://bubble.io/">Bubble</a> and <a href="https://www.tooljet.com/">Tooljet</a>.</p>
<img src="https://docs.appsmith.com/img/appsmith_logo_white.png" alt="Dash 2" style="max-width: 100%;">
<p>We recently comparared multiple dashboarding tools, and we decided to go ahead with Appsmith. Some of the deciding factors were:</p>
<ol>
  <li>Super easy to build a dashboard</li>
  <li>Appsmith is open source (hence trustworthy)</li>
  <li>Appsmith can be easily self hosted</li>
</ol>
<h2>Self hosting</h2>
<p>
  It was actually pretty easy to deploy a docker instance of Appsmith locally, build a dashboard with metrics, tables and charts with data coming from backend apis, and show a demo to customers within a day.
  Imagine if we had tried to build this in Nextjs ourselves, we'd have taken a couple of days just to finalize the designs.
</p>
<pre><code>Speed is the biggest advantage startups have !
</code></pre>
<p>One of the biggest benefits of existing widgets is that you dont have to design the UI, its kind of comes pre-existing. It also gives you a good way of putting together a design in a matter of minutes, and see for yourself how it looks.</p>
<p>Using Appsmith, we were able to create our <a href="/posts/schedule-messages-to-be-sent">Whatsapp scheduler and automation</a> dashboards in under 2 hours:</p>
<img src="https://storage.googleapis.com/supergroup-images-2/1687467381-pic-3.png" alt="Dash 2" style="max-width: 100%;"><br>
<p>
  and this:
  
  <img src="https://storage.googleapis.com/supergroup-images-2/1687467381-pic-1.png" alt="Dash 1" style="max-width: 100%;">
</p><br>Here's a dashboard for image analysis on the group:

<img src="https://storage.googleapis.com/supergroup-images-2/1687467381-pic-2.png" alt="Dash 2" style="max-width: 100%;"><br>Another dashboard for measuring actively engaged audience and read times across multiple groups:

<img src="https://storage.googleapis.com/supergroup-images-2/1690888407-dashboard-read-timings.png" alt="Dash 3" style="max-width: 100%;">
<p>Since Appsmith is open source, worst case if it comes to it, you can just fix the bugs yourself and deploy. Also, most dashboarding tools have a user based pricing, which means if your team size or your customer's team size is more than 5 people, you end up paying quite a lot of money. Self hosting Appsmith is also super easy.</p>
<p>While this may not be what Appsmith had in mind, but lets be thankful to the wonderful piece of technology they have created. And we're happy to contribute back .</p>
<h2>Widgets</h2>
<p>Here are some widgets we found super useful:</p>
<ul>
  <li><strong>Left bar navigation</strong> for multiple pages within the same app. This makes it easy to navigate between pages without having to build a custom component yourself.</li>
  <li><strong>Dropdowns</strong> for filtering are super easy</li>
  <li><strong>Tables</strong> are super easy. For dummy data, configuring columns are a little painful, but if your data comes from a datasource (API, Database ...), it works out of the box very well. We hooked up our JSON api to tables, and it just worked.</li>
  <li><strong>Tabs</strong> works really well, its super easy to setup multiple tabbed content without requiring complex javascripts</li>
  <li><strong>Charts</strong> work out of the box. While the options are limited, but I found them super easy to setup and get a gist of whats happening</li>
  <li><strong>Export and import</strong> of dashboards works really well</li>
  <li>Very easy to <strong>add users</strong> to apps</li>
  <li>Great set of <strong>data source integrations</strong>. It was super easy to start with Google sheets to get a preview of what our dashboard could look like, and then move it to an API</li>
</ul>
<h3>Limitations of Appsmith</h3>
<p>While Appsmith is a great tool, there are some limitation we came across:</p>
<ul>
  <li>The dashboard isn't responsive (mobile layout)</li>
  <li>Current selected row JS doesn't work well in tables</li>
  <li>Pie charts and line charts need more config options</li>
</ul>
<p>But overall I would rate Appsmith above any other dashboarding tools because of the design philosophy and the <strong>open source</strong> approach they have taken. Open source adds a lot of trust in the mission statement of the product.</p>
<hr>
<h2>Try SuperGroup now</h2>
<p>
  Wanna supercharge your Whatsapp &#x26; communities ?
  <a href="/#contactus">Try SuperGroup now</a>
</p>


Appsmith for building pretty dashboards


<h3>Why</h3>
<p>
  Whatsapp is amazing in the way it's super easy to use. From our parents to 10 year olds, everyone's on Whatsapp. It's end to end encrypted messaging also assures people that chats are private and cannot be read by any third party.
  And yet its missing even the most basic analytics like number of users, number of posts, who posts frequently etc.
</p>
<h3>Analytics</h3>
<p>Some basic analytics needed by every group owner</p>
<ol>
  <li>Group admins need to know who is most active, who is repeat offender, who is not responding &#x26; missing out</li>
  <li>Time of day when users are most active</li>
  <li>
    Info on how many users have read my post
    When was the last time admin posted on a group
    How many unread messages since the last time, and any specific mentions
  </li>
</ol>
<h3>Unanswered Queries</h3>
<p>
  A lot of times users or customers are waiting for an input, or a response from you on something. It can get very difficult to stay on top of these since most people have 1 Whatsapp account for their personal &#x26; private conversations. Add to it that once at any given time, you may have 100+ conversations happening.
  SuperGroup can help you stay on top of unanswered queries so you dont miss out.
</p>
<h3>Spam</h3>
<p>
  It's a pain to see random forwards / spam in a group that you have carefully curated and built. It's super important to act on it asap.
  Thankfully now Whatsapp allows group admins to remove spam posts. But you still need to stay on top of every post on the group and act quickly. What if there were a better way ? A bot that could identify potentially harmful posts and alert you ? A bot that could delete very high probability spam posts ?
  Whatsapp has partnered with <a href="https://faq.whatsapp.com/528263691226435/?locale=en_US">IFCN Fact Checking Organizations</a>. Imagine you could automatically weed out such posts.
</p>
<h3>Improve engagement</h3>
<p>An engaged audience is one of the best tools at your disposal. Some of the most powerful people in history were not born rich, but people followed them and they knew the power of an audience. For community managers, SuperGroup provides an engagement score and insights into what steps you should take to improve it. These actionable insights will let you manage your groups better and get the best out of it.</p>
<h3>Improved Search</h3>
<p>
  Whatsapp can be very difficult to search. Because exact spellings need to match. It's also difficult to search around a particular date range, nor can you search by a specific user.
  SuperGroup lets you do this with ease.
  SuperGroup also lets you search over deleted messages so you know if there are any patterns there.
  SuperGroup also lets you search over images like bill copies, payment screenshots etc using an inbuilt OCR.
</p>
<h3>Sentiment &#x26; topic analysis</h3>
<p>SuperGroup also does sentiment analysis on the group and provides insights.</p>
<h3>Backup</h3>
<p>
  With SuperGroup you can backup the images / videos / files being shared automatically, so this way you don't lose that important pitch deck that your friend shared.
  This also lets you free up space on your phone.
</p>
<h3>Phone migration is painful</h3>
<p>
  Ever tried migrating your Whatsapp chats to a new phone ? Polls show that 70% of times users are unable to migrate their data across phones (iOS to Android and vice versa). While its okay to miss out on some chats, it certainly is a big problem if you lose your business chats. That is a direct monetary loss.
  One of the things that SuperGroup does well for you is remove this limitation altogether. Never are your important business groups going to be dependent on your phone.
</p>
<h3>Disappearing messages</h3>
<p>A lot of times you need to enable disappearing messages to save on memory / phone storage. SuperGroup helps there too.</p>
<h3>Thread view</h3>
<p>
  A lot of times we want to see whether people have replied to your query / message. This is super difficult to do in Whatsapp because you have to manually scroll and read hundreds of messages.
  SuperGroup provides a great thread view out of the box, in addition to reactions on your message. This way you can see the real activity your posts create.
  SuperGroup also lets you see messages that mention you.
</p>
<h3>Polls</h3>
<p>
  Whatsapp now has polls, and its a feature I really love because its one of the simplest ways to gather insights from users. People dont have to think much.
  And yet if you wanted to do anything meaningful with a poll, like segregate users who voted for or against something, you need to manually sit and note the contact info of the voters.
  Not so convenient anymore huh.
</p>
<p>SuperGroup is the simplest way to export data into excel or csv.</p>
<h3>CRM integration</h3>
<p>
  One of the things Whatsapp sorely misses is a CRM integratio. Managing vendor &#x26; customer groups Whatsapp can be quite painful if everything needs to be entered manually into your CRM. At times you want to see simple things like what did this user say ? When was it reported ? Automatic ticket creation.
  SuperGroup works with a variety of CRMs like Zoho, quickbooks, freshworks ...
</p>
<h3>User management</h3>
<p>
  Businesses using Google suite or Microsoft tools have a good set of options to remove users and limit their access once they're no longer part of the company. However, no such thing is possible with Whatsapp.
  With SuperGroup, you never have to worry about old employees hanging around your important groups.
</p>
<h3>See older posts</h3>
<p>
  Ever wish that you could see posts before you joined a group ? Imagine how useful the added context would be for your business and the agent who supports the customer. They could see what the previous agent had done.
  With SuperGroup, you can import an entire group history and share it with other users in your organization.
</p>
<h3>User analytics</h3>
<p>New users joining, and users who have left are great leads to go after. SuperGroup gives you the ability to identify and retarget them.</p>
<h3>Data Encryption</h3>
<p>In this advanced mode, SuperGroup stores all the data in an encrypted fashion so that only you can decipher it.</p>
<h3>Group bot</h3>
<p>SuperGroup will also let you create a group bot that can take care of regular tasks like delete spam posts etc.</p>
<h3>Summary analytics</h3>
<p>Whatsapp group on autopilot - get a summary of what happened in your group every night. Users joined, users left, photos etc posted, escalations, urgent issues, spam ...</p>
<h3>Image and audio analysis</h3>
<p>
  Do you have users sharing payment screenshots back on the group ? Don't you wish there was a way to automatically verify these payments without having to do it manually everytime ? How about transcribing audio messages ?
  SuperGroup does that for you.
</p>
<h3>Location tracking</h3>
<p>
  For serious business owners who use the live location feature of Whatsapp, SuperGroup can build a trace of the user location so you can access it even after the live location ends. This would be super useful for logistics &#x26; transportation use cases.
  You could just ask the user to share his live location on Whatsapp rather than having them install a new app for location tracking.
</p>
<h3>Laundy list of features</h3>
<ol>
  <li>Group admins need to know who is most active, who is repeat offender, who is not responding &#x26; missing out
    <ol>
      <li>Group admins can now delete posts in the group. This means spambot will be super useful !</li>
    </ol>
  </li>
  <li>Integrate with ticketing services like Freshdesk, Zoho</li>
  <li>Time of day when users are most active</li>
  <li>Info on how many users have read my post</li>
  <li>May need to answer urgent queries</li>
  <li>Disappearing messages don’t get stored, persistence</li>
  <li>Personal message analytics</li>
  <li>Potential user has messaged analytics</li>
  <li>Better search, synonyms / typos, languages</li>
  <li>Can free up storage on phone</li>
  <li>Thread view</li>
  <li>Summary of the group. What did I miss since I last saw ?</li>
  <li>Sentiment analysis</li>
  <li>Spam detection. Reach out to the person who has spammed</li>
  <li>See deleted messages</li>
  <li>Who replied to my message ? Segregate discussions into topics</li>
  <li>Ability to run polls on Whatsapp groups, simple reply tracking</li>
  <li>User joined / left analytics. Ability to retarget them</li>
  <li>Ability for new users to see older posts</li>
  <li>Location analytics (based on phone number) (<a href="https://trace.bharatiyamobile.com/">https://trace.bharatiyamobile.com/</a>)</li>
  <li>Whats being discussed. Aggregate analytics</li>
  <li>Who started the spam post ?</li>
  <li>Images / videos download</li>
  <li>Add a group admin to automatically ban bad actors / other maintenance tasks</li>
  <li>Capture reactions on posts</li>
  <li>Questions directed to you / mentions you may have missed replying to</li>
  <li>Full inbox capture (not just for groups)</li>
  <li>Attached files (never lose access)</li>
  <li>Store as Encrypted data - hashed with a key only the user has (super premium feature)</li>
  <li>Group admin bot that can send messages in</li>
  <li>the group</li>
  <li>Email the chat export to us, and we send you analytics</li>
  <li>Whatsapp group on autopilot - get a summary of what happened in your group every night. Users joined, users left, photos etc posted, escalations, urgent issues, spam,</li>
  <li>analyze payment screenshots :-)</li>
  <li>analyze bill copies (signed) , OCR</li>
  <li><strong>Catalog:</strong>
    <ul>
      <li>Update your catalog</li>
    </ul>
  </li>
  <li>Analyze audio messages</li>
  <li>Live Location - let drivers share live location instead of installing an app to track it.</li>
</ol>
<hr>
<h2>Try SuperGroup now</h2>
<p>
  Wanna supercharge your Whatsapp &#x26; communities ?
  <a href="/#contactus">Try SuperGroup now</a>
</p>


Benefits of SuperGroup


<p>Praveen and I connected around Feb 2020. Praveen is on a mission to create a community of 1000 founders and helping them enable $10 Million ARR by 2030. It's a super ambitious goal, but having seen Praveen in action I think he's already on the right track.</p>
<p>One of the things that makes 1000founders community super tight knit is Praveen's utmost care in ensuring that founders derive value from the community. Some things Praveen does really weel:</p>
<ul>
  <li>no query goes unanswered, no matter how small. If nobody else responds, Praveen personally responds</li>
  <li>a strict NO SPAM policy. Posts are fine with the right context, but no random forwards. This keeps the community super engaged.</li>
  <li>a diverse, curated set of founders across verticals</li>
  <li>regular product demos</li>
  <li>lots of value around adjancent functional areas like fundraising, hiring, selecting the right tech stack ...</li>
</ul>
<p>
  The end result is a super engaged community:
  
  <img src="https://storage.cloud.google.com/supergroup-images-2/1672891953-1000f.png" alt="1000 founders" title="1000 Founders">
</p>
<hr>
<p>We'll be diving deeper into more details of Praveen's mission and how he plans to make it happen in a podcast soon, watch this space for more updates!</p>
<p><a href="https://1000founders.in/">Join 1000 founders</a></p>
<hr>
<h2>Try SuperGroup now</h2>
<p>
  Wanna supercharge your Whatsapp &#x26; communities ?
  <a href="/#contactus">Try SuperGroup now</a>
</p>


How Praveen Singh aims to create a community of 1000 founders


<p>Kumar Ranjan is a seasoned entrepreneur, having started a few and seen his last one get acquired. Kumar in his latest avatar is aiming to solve the animal nutrition problem in India. Given the size of the animal husbandry industry in India, makes you wonder why there are still so many problems that farmers face. This is where eFeed comes in.</p>
<h3>eFeed and Whatsapp</h3>
<p>Whatsapp is beyond any doubt the most engaging social media platform to build a community on. Part of eFeed's success comes from the fact that they manage 50+ communitie of farmers across geographies.</p>
<p>
  Imagine waking up to this every morning:
  
  <img src="https://storage.googleapis.com/supergroup-images-2/1672905827-efeed-groups.png" alt="Efeed groups" title="Efeed groups">
</p>
<p>
  Inside one of your groups might be an important query like:
  
  <img src="https://storage.googleapis.com/supergroup-images-2/1672905606-efeed-query.png" alt="Important query" title="Important query">
</p>
<p>As you can imagine, this gets super hard when you have 20 other things happening that suck your time like fundraising, hiring, opening new stores ...</p>
<h3>SuperGroup to the rescue 🚀</h3>
<p>
  With SuperGroup dashboard, Kumar can see all his groups in one place, measure the turn around time for queries, identify missed queries and much more.
  This way Kumar is on top of his groups, without having to read every message every time.
</p>
<hr>
<h2>Try SuperGroup now</h2>
<p>
  Wanna supercharge your Whatsapp &#x26; communities ?
  <a href="/#contactus">Try SuperGroup now</a>
</p>


How eFeed is helping a community of farmers to get better yields


<p>Binu Mathew is a CA by profession and runs PokketCFO - a group of professionals consisting of Chartered Accountants, Lawyers and Company Secretaries managing business finance and related compliance and making founder’s feel less anxious and more empowered by their business.</p>
<p>Binu manages the compliances for multiple companies (including mine) and a commonly accepted knowledge today is that if you need to get something done, Whatsapp. Email is slow and too official, so people spend more time proof reading what they wrote. Slack gets confusing very quickly, and nobody uses Discord for such communications. Most of these time sensitive conversations happen on Whatsapp groups.</p>
<p>Herein lies the pain. How do you stay on top of multiple groups ?</p>
<h3>SuperGroup 🚀</h3>
<p>One thing every business absolutely needs is to be on top of things, surprises can be very expensive. And the best way of staying on top is to have a birds eye view of your entire business, especially the areas that need help.</p>
<p>With SuperGroup dashboard, Binu can see all his groups in one place, measure the turn around time for queries, identify sentiments and configure alerts on selected events happening. This way Binu is not caught off-guard and can actually spend his energies expanding, rather than just operationally managing his existing set of clients.</p>
<pre style="background: #f5f2f0; color: #000000; font-family: Consolas,Monaco,&#x27;Andale Mono&#x27;,&#x27;Ubuntu Mono&#x27;,monospace">A founder can't not know his top business metrics!
- Binu
</pre>
<hr>
<h2>Try SuperGroup now</h2>
<p>
  Wanna supercharge your Whatsapp &#x26; communities ?
  <a href="/#contactus">Try SuperGroup now</a>
</p>


How PokketCFO uses SuperGroup to power their client communications


<p>Whatsapp is amazing in the way it's super easy to use. From our parents to 10 year olds, everyone's on Whatsapp. It's end to end encrypted messaging also assures people that chats are private and cannot be read by third parties including Whatsapp itself.</p>
<p>
  However, if you run your business on Whatsapp, you soon find the lack of observability a limitation. After all, you cannot improve what you cannot measure.
  Binu runs a successful CA practice and ends up checking his client groups to ensure that no message got missed. Traditionally sales folks manage this using a ticketing service like freshworks or Zoho, however Whatsapp groups have so such integrations.
</p>
<h4>This changes now</h4>
<p>SuperGroup solves this. With SuperGroup, you'll be able to do everything you can do with Slack or google chat, while still keeping your chats private.</p>
<p>
  <img src="https://storage.googleapis.com/supergroup-images-2/1672394171-sg-dashboard.png" alt="dashboard" title="dashboard">
</p>
<hr>
<h2>Try SuperGroup now</h2>
<p>
  Wanna supercharge your Whatsapp &#x26; communities ?
  <a href="/#contactus">Try SuperGroup now</a>
</p>


Observability for Whatsapp groups


<p>These days there's hardly anyone not on Whatsapp, from business professionals to households. Every household also has a family group on Whatsapp where folks keep sharing photos / videos of events that happen.</p>
<div style="display: flex; flex-direction: row; justify-content: center">
  <img src="https://storage.googleapis.com/supergroup-images-2/1684595771-family.jpg" alt="Family group" style="max-width: 60%;">
</div>
<p>
  After talking to users, we've come to the realization that media backup is still a major pain. The core issue is that Whatsapp &#x26; Google photos don't work well together. You can either backup all your Whatsapp media to Google photos, or not backup anything at all.
  The problem is, users <strong>don't</strong> want to backup the <strong>random junk</strong> they receive on certain groups. But they do want a backup of the media shared on the family groups ??
</p>
<div style="display: flex; flex-direction: row; justify-content: center">
  <img src="https://storage.googleapis.com/supergroup-images-2/1684596555-wToG.jpg" alt="Family group" style="max-width: 70%;">
</div>
<p>Imagine going for on a vacation with your loved ones. How are you going to save and share the amazing photos / videos you took on the trip. Advanced users would probably create a folder in Google photos and save them. But how are you going to share the pictures with your family. Or look at the ones that your significant half took from their phone.</p>
<pre><code>👍 Whatsapp silly !
</code></pre>
<p>Why should it be so hard to selectively backup the media shared on your important family groups to Google drive / Google photos ?</p>
<hr>
<h2>Enter SuperGroup</h2>
<p>Today we're annoucing the Google Drive integration with SuperGroup 🚀</p>
<p>All you have to do is <a href="/posts/how-to-add-your-group">link your family groups with SuperGroup</a> and enable the Google Drive integration. Lets go through the steps.</p>
<h3>Step 1. Make a new folder in Google drive</h3>
<img src="https://storage.googleapis.com/supergroup-images-2/1684597148-pic1.png" alt="Family group" style="max-width: 70%;">
<img src="https://storage.googleapis.com/supergroup-images-2/1684597148-pic2.png" alt="Family group" style="max-width: 70%;">
<h3>Step 2. Share the folder with SuperGroup</h3>
<img src="https://storage.googleapis.com/supergroup-images-2/1684597148-pic3.png" alt="Family group" style="max-width: 70%;">
<img src="https://storage.googleapis.com/supergroup-images-2/1684597148-pic4.png" alt="Family group" style="max-width: 70%;">
Share the folder with google-sheets-updater@oauth-app-368203.iam.gserviceaccount.com <button id="copyBtn2" style="text-decoration: underline;" onclick="navigator.clipboard.writeText(&#x27;google-sheets-updater@oauth-app-368203.iam.gserviceaccount.com&#x27;); document.getElementById(&#x27;copyBtn2&#x27;).innerText = &#x27;COPIED&#x27;">COPY</button> so that SuperGroup can upload media on your behalf.
<h3>Step 3. Put the folder url in the SuperGroup dashboard</h3>
<img src="https://storage.googleapis.com/supergroup-images-2/1684694227-drive-int.png" alt="Family group" style="max-width: 70%;">
<p>
  Go to the integrations tab, and enter the url of the folder you just created under <strong>Google drive</strong> and click the <strong>Add</strong> button.
  You can pause the sync if in case you choose to.
</p>
<h3>Step 4. Add the SuperGroup number to your family groups</h3>
<p>Follow <a href="/posts/how-to-add-your-group">this tutorial</a> to link your family groups with SuperGroup. In short:</p>
<p>Add the SuperGroup number to your Whatsapp group 👇</p>
<div style="display: flex; flex-direction: row">
  <div style="color: green; font-size: 24px; margin-right: 30px;">+91-97034-57129</div><button id="copyBtn" style="text-decoration: underline;" onclick="navigator.clipboard.writeText(&#x27;9703457129&#x27;); document.getElementById(&#x27;copyBtn&#x27;).innerText = &#x27;COPIED&#x27;">COPY</button>
</div>
<p>We currently approve group requests manually every 2 hours. Yours should get approved soon.</p>
<h3>Step 5. Sit back and enjoy</h3>
<p>Your precious photos &#x26; videos should now start getting backed up in your Google drive folder. You can easily view them, import them into Google Photos or share them however you like without having to worry about losing them. And once you disable the Google photos backup option from Whatsapp, you'll be able to save lots of space on your Google photos account.</p>
<h2>And you're all set 🚀</h2>
<hr>
<h2>Try SuperGroup now</h2>
<p>
  Wanna supercharge your Whatsapp &#x26; communities ?
  <a href="/#contactus">Try SuperGroup now</a>
</p>


Sync photos / videos to your Google drive


<p>
  <img src="https://about.fb.com/wp-content/uploads/2022/03/01_Voice-Messages_7-Billion.png?resize=890%2C501" alt="voice messages" title="voice messages">
  <strong>7 Billion voice messages are sent daily on Whatsapp</strong> (<a href="https://about.fb.com/news/2022/03/new-voice-message-features-on-whatsapp">source</a>). That's a staggeringingly big number. If you're wondering whats so special about audio messages, think about the emotion and sentiment they communicate which are just not possible in a normal text message.
  And yet its difficult to search over voice messages, or analyse the sentiment programatically.
</p>
<p>This makes voice messages perfect for capturing user feedback !</p>
<h2>Sounds good, but how do I analyse voice messages ?</h2>
<p>With SuperGroup, you can configure webhooks to get audio transcripts (and raw data) sent to your server in near reatime. You can then use a speech recognizer that can help you recognize text, volume, sentiment and more.</p>
<p>
  All you have to do is <a href="mailto:contact@supergroup.ai?subject=I%20want%20to%20setup%20audio%20webhooks&#x26;body=The%20webhook%20url%20is%20XXX">Setup audio webhooks</a>.
  Our team will approve the webhook for your account and you can start receiving webhooks with audio payload in them.
</p>
<h2>And you're all set 🚀</h2>
<hr>
<h2>Try SuperGroup now</h2>
<p>
  Wanna supercharge your Whatsapp &#x26; communities ?
  <a href="/#contactus">Try SuperGroup now</a>
</p>


Transcribing audio messages with SuperGroup


<p>Whatsapp recently launched the communities feature, which lets you organize &#x26; manage multiple groups under one space. There are tons of interesting communities on Whatsapp today, including a super engaged Xoogler community managed by a bunch of ex-google folks.</p>
<p>It's interesting to evaluate what great engagement looks like. Following are stats from 3 communities:</p>
<h3>Community 1</h3>
<p>
  <img src="https://storage.cloud.google.com/supergroup-images-2/1672390015-community-c1.png" alt="Community 1" title="Community 1">
  has a healthy reactions to messages ratio of <strong>0.69</strong>.
</p>
<h3>Community 2</h3>
<p>
  <img src="https://storage.cloud.google.com/supergroup-images-2/1672390025-community-c2.png" alt="Community 2" title="Community 2">
  has a reactions to messages ratio of 0.27 indicating that only one in every 3 messages gets a reaction, but a healthy reply ratio of <strong>28%</strong> which means that most queries on the group must be get answered.
</p>
<h3>Community 3</h3>
<p>
  <img src="https://storage.cloud.google.com/supergroup-images-2/1672390029-community-c3.png" alt="Community 3" title="Community 3">
  is the least engaged community with very few reactions &#x26; replies. This is reflective of announcement only groups, or groups with a handful of creators, and most participants are passive. Interestingly SuperGroup can also suggest ways of improving the engagement score for such communities.
</p>
<h2>Engagement score</h2>
<p>At SuperGroup, we're working on coming up with a comprehensive vector of engagement scores which can indicate to the group admins where their community stands with respect to others.</p>
<p>Watch this space for more info soon !</p>
<hr>
<h2>Try SuperGroup now</h2>
<p>
  Wanna supercharge your Whatsapp &#x26; communities ?
  <a href="/#contactus">Try SuperGroup now</a>
</p>


What an engaged community looks like


<h2>User attention</h2>
<p>We're all part of many Whatsapp communities &#x26; groups these days where we seek out guidance and help. Have you ever found yourself wondering:</p>
<ul>
  <li>How to get the attention of a group ?</li>
  <li>Whats the best time to post a query, or an announcement ?</li>
  <li>Should you post when theres less activity on the group, in the hopes that you don't get interrupted and more people see your post ?</li>
  <li>Or should you instead post when the group is most active ?</li>
</ul>
<p>Chances are, you might have thought about this on more than one occasion.</p>
<h2>What does the data show ?</h2>
<p>SuperGroup's mission statement is to enable users to get more value out of the community. Since we capture all the messages being sent, we can focus our attention to replies or quoted messages.</p>
<p>One way to visualize this is to plot the number of messages &#x26; time between the original message, and the reply.</p>
<p>
  <img src="https://storage.googleapis.com/supergroup-images-2/1677186672-reply-quoted-message.png" alt="reply" title="reply">
  Say post <strong>P2</strong> is a reply to post <strong>P1</strong>. We should look at the number of messages in between, and the time difference in between.
</p>
<h3>Data structures</h3>
<p>For every post with a quoted message, lets save this data structure:</p>
<pre><code class="language-javascript">class Post {
    replyId: string;
    quotedMessageId: string;
    groupId: string;
    numMessagesDelta: int;
    timeDeltaMs: int;
}
</code></pre>
<p>We should plot numMessagesDelta and timeDeltaMs. And look at the percentiles (<strong>tp50</strong>, <strong>tp95</strong>, <strong>tp99</strong>) to get a sense of whats happening.</p>
<h4>Number of messages sent between replies</h4>
<p>
  <img src="https://storage.googleapis.com/supergroup-images-2/1677182912-num-messages-between-replies.png" alt="# messages between replies" title="# messages between replies">
  The graph shows that majority of the replies have between 1 to 10 other messages exchanged in between the reply and the original message. Some have between 10 and 20 messages. The bulk of the weight is between 0 to 20 messages.
</p>
<p>This suggests that posts older than the 20 latest are unlikely to get replies or comments.</p>
<h4>Number of minutes between replies</h4>
<p>
  <img src="https://storage.googleapis.com/supergroup-images-2/1677182913-minutes-between-replies.png" alt="minutes between replies" title="minutes between replies">
  The graph shows that majority of the replies occur between 0.3 and 25 minutes from the original message. Some replies go upto 50 minutes. Again, its safe to say that the chances of getting a reply after 60 minutes is low.
</p>
<p>
  Note that this pattern is usual of professional groups. Personal groups tend to be smaller and sometimes more sporadic.
  
  <img src="https://storage.googleapis.com/supergroup-images-2/1677188008-group-comparison.png" alt="group comparison" title="group comparison">
</p>
<h2>Moral of the story</h2>
<blockquote>
  <p>Out of sight, out of mind.</p>
</blockquote>
<p>You want to post when the group is starting to get engaged, and be the reason that engages the group 😀</p>
<p><a href="/#contactus">Reach out</a> if you'd like to get insights for your groups &#x26; communities.</p>
<hr>
<h2>Try SuperGroup now</h2>
<p>
  Wanna supercharge your community ?
  <a href="/#contactus">Try SuperGroup now</a>
</p>


SuperGroup tech

Send scheduled messages using SuperGroup

Step 1. Make a copy of the Google sheet template

Step 2. Update the SG_Scheduler sheet with your messages

Step 3. Share the sheet with SuperGroup

Step 4.

Sending media

And you're all set 🚀

Try SuperGroup now

Address

Phone

Email

Social