Export activities to Google worksheets using the API

I would like to automatically export all new activities to google worksheet every 24 hours. The best way is to use script.google.com instead of the third service.
I can use *.gs language but the total puzzle is for me how to connect it with Pipedrive API.
I will be grateful for every clue.
My current goal is to get in touch with the pipedriv using GoogleScript.

Hi,
You might find the following wikis useful
https://devcommunity.pipedrive.com/t/importing-and-exporting-data/4963/2

https://devcommunity.pipedrive.com/t/using-google-app-scripts-for-automation-integration/4959/2

Feel free to create a new topic if you still face challenges.