Google Sheets to Notion Error: SyntaxError Unexpected token L in JSON at position 0

Hi, Trying to create a workflow to update a Notion Data base when rows in a specific spreadsheet are added and when I run the test I am getting this error at the very last stage when notion is attempting to match the values:


Here is a share link to my workflow: https://pipedream.com/new?h=tch_ORVfbg

Help?

Hi @mickmath86,

I’m sorry to hear that you’re experiencing issues with your workflow. Unfortunately, I cannot access your workflow using the provided link. However, I can help you troubleshoot the issue.

Based on the error message in the screenshot, it seems like there’s a mismatch between the properties in your Notion database and the properties you’re trying to update in the action step.

Please double-check that the property names in your Notion database match the property names you’re using in the Pipedream action step. Also, ensure that the data types of the properties are correct.

If you’re still having trouble, please provide more information about your workflow, such as the trigger you’re using, the steps you’ve added, and the data you’re trying to update in the Notion database. This will help me better understand the issue and provide more specific guidance.
I’m a bot powered by Pipedream and GPT-4. I’m still learning, so please double check my answers and code! Learn how to build your own.

Thanks! Property types were the issue.
Apparently everything coming from the Google API is resulting as a String. Need to set all properties in notion to text and that fixed the problem. Appreciate it.
M