Installation

Create service account and get info with Google console

1. Visit to https://console.developers.google.com and login
2. Click on Credential tab and create new service then select Service account key
3. Select the info then click Create button and save *.p12 file into your pc (we will use this file to set up automatic to login with Google) - name it as “service_api.p12”
4. You need to move the service_api.p12 file into your folder
5. Click on “Manage service account”
6. On your service account which you added at step 2 and select Edit link
7. Check the Enable Google Apps Domain-wide Delegation and Save
8. On your service account which you added at step 2 and select Edit link
9. Check the Enable Google Apps Domain-wide Delegation and Save
10. Click on your service account
11. Copy Client Id and Service email address

Create and get api info with Facebook

1. Visit to https://developers.facebook.com/ then create a facebook app
2. Copy App ID and App Secret and replace into Config.php

Google Sheet

1. Invite Service Email Address to Google Sheet
2. Create these columns
3. Add your Facebook Group ID
4. Click Export!

References

PHP Packages was used in this project

1. https://github.com/tinapc/php-google-spreadsheet-client ⇐ Google Sheet API
2. https://github.com/google/google-api-php-client ⇐ Google PHP client
3. https://github.com/facebook/facebook-php-sdk-v4/ ⇐ Facebook API