← ClaudeAtlas

create-customer-reference-records-in-shared-project-listlisted

Build a Zap on Zapier that adds or updates a customer's reference record in a shared SharePoint list whenever a new customer is created in QuickBooks Online. Use when a sales or enablement team keeps a shared list of customer references and wants it filled in from the accounting system without manual entry.
zapier/awesome-zaps · ★ 2 · AI & Automation · score 78
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