How to get my contacts to Google Sheets via sheet script without down-or uploading or importing exporting method.
getAddress()
doesn't work for me
this is not an answer, but i have to, because the above box is too small for this matter.
function Importcontacts_2() {
var group = ContactsApp.getContactGroup('family');
var contacts = group.getContacts();
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
sheet.appendRow(['Full Name', 'Email Address','Home Adress' ]);
for (var i in contacts)
{
var fullname=contacts[i].getFullName();
var emailid=contacts[i].getEmails();
var home_adress=contacts[i].getAddresses(ContactsApp.Field.HOME_ADDRESS);
for(i in emailid)
{
sheet.appendRow([fullname, emailid[i].getAddress()]);// append contact data to active sheet
}
}
}