How To Setup Google Sheet On Pingtree Systems?

By Author: pingtreesystems
Total Articles: 1
Comment this article

The Ping tree system is one of the most popular leading management software in all over the world. We Provide an admin panel system for clients to sell and buy leads in an easy way with multiple free services. We give first priority for client service and satisfaction. If you want to send leads into Google Sheet then use this feature. It's very helpful . To use this feature then add Client ID, Client Secret ID and Refresh Token and to Get Refresh Token then click on Get Refresh Token link.Copy Refresh Token text from the new page then paste into Refresh Token textbox. Below steps give detailed information.

1. Login into your gmail account and open this link https://console.developers.google.com/
2. Click on "Select Project" and then click on "New Project".
3. Fill up the form and click the "CREATE" button.
4. Search this keyword in the top search box - "google sheet api" and Enable API.
5. Then you need to create Credentials for Client ID and Client Secret. Click on Create Credentials button and select "OAuth client ID"
6. Select Web Application in Application type.
7. ...
... You need to add Your PTS URL after the Login URL "Authorized JavaScript origins" section.
8. Add Your PTS URL "Authorized redirect URIs" section
9. Click the "Save" button.
10. Now you just copy Client ID and Client Secret and Paste into PTS Systems- https://prnt.sc/26pyu7t
11. After added Client ID and Client Secret into system you just click "Save For Token" button - https://prnt.sc/26pyvz6
12. Once you save token then click "Get Refresh Token" button and copy & paste Refresh Token into textbox that you given from this link - https://prnt.sc/26pywu4
13. All Set.

Also you can follow steps as per below video click on this link to watch:
https://www.pingtreesystems.com/faq/how-to-setup-google-sheet