Choose what each record represents
Prepare the Notion database and properties before connecting the Zap. You need edit access to the workspace and must grant Zapier access to the specific database or pages.
Payment Paid includes renewals and instalments. Use it for a payment log; if the task should only be created once per purchase, add the repeat-action check before creating the item.
Create the Notion item
- Connect Newie to Zapier, then choose the Newie trigger for your record. If only one service belongs in the database, add an Offering ID filter immediately after the trigger, before creating the item.
- Connect Notion and grant access to the database. If it does not appear in Zapier, reopen the connection’s permissions and add it.
- Choose Create Data Source Item and select the data source for that database.
- Map the Newie fields to the properties you prepared. Use
subscriptionIDfor Subscription ID, orstripeInvoiceIDfor Invoice ID. Use the exact option names for Select and Status fields. - Test the Zap and check the resulting record before turning it on.
stripeInvoiceID as the invoice ID. Convert amount from minor units before storing a decimal amount: for AUD or USD, 1060 becomes 10.60. Keep the currency and follow the payment-field mapping guidance for other currencies. Fill Date logged with the Zap run time; the payment trigger does not supply a dedicated payment-confirmation timestamp.
Update an existing item
Use Find Data Source Items before Update Data Source Item. For Subscription Ends, search the database’s Subscription ID property for Newie’ssubscriptionID. Pass the matching Notion item from the search into the update step, then change its status. Searching only by customer email can change the wrong record when someone has bought more than one service.
For a recovered overdue invoice, use Payment Paid and match its invoice ID to the follow-up task before closing it. For a workflow that only closes overdue tasks, do not create a new item when the search finds no match.
If you rename properties, check and remap the Zap. The current Notion action list uses “Data Source Item”; older Zaps may still show “Database Item.”
Last updated: 2026-09-09