- You can easily integrate Google Sheets with Groupboss. At first, choose the group where you want to integrate. Then click on the icon ‘Settings.’
2. After that, you need to enter your Google Sheet URL and connect.
3. Now you need to create a shareable Google spreadsheet link.
To create a Google spreadsheet, you can take the help of the following steps.
a. Go to Google Drive.
b. Sign in to your Google ID.
c. Select Google Sheets, and you will find a Blank spreadsheet. (You can keep the name of your spreadsheet similar to your Facebook group name.)
4. To collect the shareable link of the Google spreadsheet, you can follow these steps:
a. Click on Share which you will find in the top right corner of the spreadsheet.
b. Change the command from ‘Restricted’ to ‘Anyone with the link’ to ‘Editor.’
5. Now copy the link and paste the link in the Groupboss Chrome extension. Once you have pasted the link, click on connect. And it’s done.
Now check…. Before configuration: No headings are there.
After Configuration: Headings appeared after configuration.
6. Go to the Member Request option of your Specific Facebook group and approve the requests by clicking on Approve by Groupboss and Approve All By Groupboss.
7. After approving the requests, go to Google Spreadsheet. Then you will see that the information of the members, whose requests you have approved is updated in the spreadsheet.
This is how you can integrate Google Sheets with Groupboss.
