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.

You might find the following wikis useful


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