Flow, Add Row to Google Sheets - Error: action does not return data so output will always be NULL

[MGR-NZ]

Hi Community

First post newbie here but wish I had signed up sooner.

Have picked up Flow recently and now have working automations for product data and metadata.  One of my metadata fields is a unique product ID that I want for easier product identification.  There's probably an easier way to update this field but I ended up using a spreadsheet with 3 columns:

Product.Handle / Product.title / ID 

The 'ID' column (3rd column) is prepopulated with an incremental ID number and I want to add the product handle and product title in the first two columns. 

The workflow comes back as completed without error but no data has been added to the google doc. The add row to google sheets step has picked up the correct values for handle / title from the correct worksheet but the output of the script is NULL with an error message: 'The action does not return data so the output will always be NULL' 

Screenshots are below, any help would be appreciated.

..........................................

This is my workflow and variables in the Add Row to Google step.

This is my google doc

This is result after a new product was created (Title and handle = 'Dummy Product')

[paul_n]

I don't think you can write to a row that has already been created. This action appends after the last row. So likely it's doing exactly that. If you see no output, make sure the tab name matches exactly. 

[MGR-NZ]

great thank you that makes sense, I’ll take out the third column and see what happens.

[MGR-NZ · Accepted solution]

You're correct Paul, it turns out the entries had been made down around row 300 which was where the first blank row was.  

Thanks for the easy fix.