Sync google contacts to google spreadsheet, Sync google tasks to google spreadshhet

Contacts to google spreadsheet:

I need to modify this script ([url removed, login to view] ) to make it all my google contacts import to a google sheets file. I’ve already tried to run it, but it does not import all the available contact fields (as array, separated by comma) - for ex. address, IM and others are missing. So I don’t want you to make a new script, but just to make a modification. The things that I want to be changed: -The contact link (column 1) has to be changed to [url removed, login to view]<Contact ID> (it parses ID correctly) -The file doesn’t contain all the standard fields (it shall contain name, all the phone numbers, all the emails, address, birthday, all the url’s, instant messaging etc.. If there are more fields in the google contacts, they should be added to the sheet as well. Custom fields (non standard) should also be added in a separate columns if present. However this function if difficult to implement is not necessary (the custom fields). Note about the phone numbers, emails and any other fields – some people have several of them, so it’s ok if they are in one cell added as array, separated by commas. -There is also a column “date last contacted” in original sheet which syncs back to google contacts, it shouldn’t be there. I only need one way sync google contacts to spreadsheet. The script should run weekly. But I saw there are many functions in the script. Which one should be run to make full sync? If one is not enough, please make modification to include a function that runs a full sync on all table, that I can easily make a single trigger for that.

Tasks to google spreadsheet:

I need to sync my google tasks to google spreadsheet on trigger every day. Similar to what this script does for calendar: [url removed, login to view] For tasks I also need a time interval to be set. as if too much tasks script can timeout. I do not need the text filtering functionality as in the calendar script. Filtering by search phrase is available there.

Both scripts should be included in the google spreadsheet file that I would copy from you.

Google App Engine

ID do Projeto: #8830226

Sobre o projeto