---
title: "Adding data from spreadsheet to custom fields in Google Contacts with Google Apps Script"
author: "Martin Hawksey"
date: 2019-11-27T10:17:00+00:00
modified: 2019-11-25T22:18:48+00:00
canonical_url: https://pulse.appsscript.info/p/2019/11/adding-data-from-spreadsheet-to-custom-fields-in-google-contacts-with-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2019/11/adding-data-from-spreadsheet-to-custom-fields-in-google-contacts-with-google-apps-script.md
categories:
  - "Contacts"
  - "Sheets"
  - "Snippet"
  - "Solutions"
tags:
  - "@timmermariette"
  - "scriptjes.blogspot.com"
description: "At my work data of clients, opposing parties, courts, third parties and cases (among which case names) are stored in a spreadsheet. The spreadsheet is the source for contacts in Google Contacts. For some reason..."
---

# Adding data from spreadsheet to custom fields in Google Contacts with Google Apps Script

> At my work data of clients, opposing parties, courts, third parties and cases (among which case names) are stored in a spreadsheet. The spreadsheet is the source for contacts in Google Contacts.
> For some reason names of cases are used as subject in Gmail. I use(d) Google Apps Script to add case names to Google Contacts

Nice little script example to navigate around and add data to Google Contacts.

Source: *[/**There must be a better way to do it but I do not yet know how*/: Adding data from spreadsheet to custom fields in Google Contacts with GAS*](https://scriptjes.blogspot.com/2019/11/voorlopige-totel-rvr.html)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2019/11/adding-data-from-spreadsheet-to-custom-fields-in-google-contacts-with-google-apps-script/](https://pulse.appsscript.info/p/2019/11/adding-data-from-spreadsheet-to-custom-fields-in-google-contacts-with-google-apps-script/)*