I am trying to build a social media scrapper. As part of this once the data is inserted in google sheet through a webhook, n8n further processes it and scrapes the data and sends an email to the requestor. When the data first time updated in the excel sheet through webhook there is a column which gets updated as FALSE. My desire is to update it once the email sent post scraping as TRUE, so that any new data added, the next run wont consider the TRUE rows. However this is not happening at this moment.
‘Update’ your row by matching ‘row number’
your mapping for created_at column is not an expression. it is fixed
Hover over that column and when Fixed/Expression appears, select Expression
Look it the first picture, {{created_at}} must be green like values in the second picture
Thanks, This worked.
1 Like