create-customer-reference-records-in-shared-project-listlisted
Install: claude install-skill zapier/awesome-zaps
# Create customer reference records in shared project list
The Zap's code lives at https://github.com/zapier/awesome-zaps/tree/main/zaps/create-customer-reference-records-in-shared-project-list. Read the files there if this skill was installed on its own.
## What it does
1. **Trigger:** a new customer is added in `quickbooks` (`customer_v2`, New Customer).
2. **`sharepoint`** searches the shared list for an item whose customer ID column matches the customer's `Id`.
3. If a match exists, **`sharepoint`** updates that item: name, customer ID, email and phone. If not, it creates a new item with the same fields.
## Ask the user
Each `REPLACE_…` value is set per person. Resolve names to IDs with the user's own connections; don't ask them to paste an ID you can look up.
| Setting | What goes there |
| -------------------- | --------------------------------------------------------------------------------------------------------------------------------- |
| `SITE_ID` | The SharePoint site that holds the shared customer reference list: ask which site, then look up its ID |
| `LIST_ID` | The shared customer reference list on that site: ask which list, then look up its ID |
| `CUSTOMER_ID_COLUMN` | The list column that stores the QuickBooks customer ID: look up it