Hi @lpadula, applying formatting isn’t supported by the Google Sheets node I am afraid.
So if you want to apply formatting through n8n, you’d have to use HTTP Request node to directly send the required API request.
Your scenario (appending new data to a sheet, then formatting it) could look like below.
Spreadsheet
Workflow
You’d to update the spreadsheet ID on your end (in the Google Sheets and HTTP Request nodes) to test this.
Result
Now when a new row is added, it gets the background colour defined in the HTTP Request body:
While this works, I’d very much suggest to define any formatting directly in the Google Sheet itself as these API requests can get very comprehensive and hard to read.
Hope this helps 