Hi ​@shophighst 

Help link for using files in Zaps: https://zapier.com/help/create/basics/send-files-in-zaps

Try adding these Zap steps:

• Action: Files by Zapier - Line Items from CSV
  • Help: https://zapier.com/apps/files-by-zapier/integrations#help
• Action: Looping - Create Loop from Line Items
  • Help: https://zapier.com/apps/looping/help

That will allow you to get the CSV file row data, then iterate thru each row.

Thanks for the pointers!  

I successfully created the Line Items from CSV and now see the fields when I go to map them in the Update Notion Database step.  

I’m stumped on the actual means to tel zapier to “check the Notion CUSTOMER datebase and make any updates based on the CUSTOMER ID field”. I assume once that step completes, I would add the loop module to add New Items to the Notion CUSTOMER database?

​@shophighst 

Data from the Files by Zapier step should be mapped to the Looping step, then from the Looping step to the Notion steps.

For us to have more info, post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.

I currently have 4 steps in my Zap (screen shots for each step is provided below):

1.  New folder in Google Drive Folder:  Watches a specific Google Drive folder for a new CSV
2. New Items from CSV:  Pulls the data from the CSV
3. Loop (tbh - I don’t fully understand this step):  I mapped 3 fields to start - CUST ID, FIRST NAME, LAST NAME.  
4. Update Notion Database:  Need Zapier to look for a matching CUST ID and update.  However, the test is failing because the loop step seems to be creating a comma separated string of all CUST ID’s, FIRST NAMES, and LAST NAMES, rather than creating individual lines.  I’m not sure where I went wrong in configuring

Once those four steps finish, then I need Zapier to add any missing records to the Notion DBase

​@shophighst 

You currently have variables mapped from Step 2 to Step 4.

You need to map variables from the Looping Step 3 to the Step 4.

Previous guidance:

Data from the Files by Zapier step should be mapped to the Looping step, then from the Looping step to the Notion steps.

UGH!  I see that now.  I corrected, and the test failed because the “test” record is a CUST ID that is not Notion.  How would I go about telling Zapier to add that record in Notion?

I believe it worked … I used the “Find item in database” function and checked the add item if not found option at the bottom.  Going to retest now with all fields mapped.  Thanks again for the help!!!!!

Wow! Thank you for confirming that your workaround got the Zap running. This will significantly help our Community members to have as a reference for the same issue.

I’m so close (I think) … I’m now running into an error in the last step (see screenshots below).  The same error was happening on “first visit”, “last visit” and “birthday” - I deleted them form Notion and zapier, tinkered, re-added and it somehow they’ve stopped appearing (I’m hoping they don’t pop once I clear this error).

The error is:

Failed to find or create a database item in Notion

body failed validation. Fix one: body.properties.SQUARE CUST ID.id should be defined, instead was `undefined`. body.properties.SQUARE CUST ID.name should be defined, instead was `undefined`. body.properties.SQUARE CUST ID.start should be defined, instead was `undefined`.

“SQUARE CUST ID” is in the CSV file and is being loaded as “Customer ID” and going into the “Square ID” field in the Notion database.  I’ve spent a couple hours trying to figure this out and am officially stumped 

Thanks again for the help + support!!!

Hi ​@shophighst,

Before we dig deeper into this, would you mind sharing a detailed screenshot of the “CONFIGURE” section of your Notion action step? Please ensure to capture all of its fields.

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks!

Hello ​@ken.a ,

I included 3 screenshots on my last post that shows the full config screen of the Notion step.  Let me know if there’s something else that would be helpful.

Hi ​@shophighst,

It looks like you have sent a screenshot of the “Test” section of the action step. Here’s an example screenshot that you’ve sent:

(view larger)

We would need to see the “CONFIGURE” section of the Find Database step for us check the mapped fields.

I'll be keeping an eye out for your response!