How to fix workflow when a cell is empty in Notion to G.Sheets?

1

This topic was automatically generated from Slack. You can find the original thread here.

Hello,

Notion to G.Sheets. I observed when a cell is empty, the workflow doesn’t work for that particular row. How can correct this? Thanks

…

Screenshot 2023-02-28 at 11.37.18.png
Screenshot 2023-02-28 at 11.37.18.png2576×360 49.5 KB

2

> the workflow doesn’t work
Hi , would you mind provide more detail on this? What specific action does not executed as you expect?

3

okay. Give me a sec

4

Okay, notr

• I am populating my notion db from telegram. [Producer by, name]
• I have created a pipedream workflow to push every 30 seconds to googlesheet

5

• I observe, if either a cell in produced by column or name column is empty the workflow doesn’t work

6

below are screenshots of the googlesheet, when the workflow work

Screenshot 2023-02-28 at 12.07.21.png
Screenshot 2023-02-28 at 12.07.21.png1788×1070 81.4 KB

Screenshot 2023-02-28 at 12.04.09.png
Screenshot 2023-02-28 at 12.04.09.png1592×624 29.1 KB

7

How can I modify the trigger codes as shown in the pipedream screenshot to check if empty and accept regardless?

Thanks

8

HI , I’m still not sure how I can reproduce your issue.

Could you state the name of the trigger/action you are using? What is the event that trigger your workflow, then what is the expected output?

9

I think I found a way to resolve this. I’ll get back to you on this Leo. thanks

10

Posted thread to Discourse: How to Fix Workflow for Empty Cells in Notion to G.Sheets?

11

Sorry for replying late Leo. I was able to resolve it