Issue with assigning variables (from other Branches)

Questions
,
9

Hey @Graham_Beck , I do not think that “Append” is the right operation for Merge in your case.

I would imaging the following to be considered

  1. Merge could be used to pass the data from branch 2 only once input is available on both branches (“Chose branch” mode)
  2. You need to have the headers of the spreadsheet created before hand
  3. Having the headers prepopulated (not including the spreadsheet IDs) will ensure the correct automapping of the data
  4. Having access to the spreadsheet ID that was created in the workflow could be achieved by referencing the node that has that data, for example {{ $(Google Sheets).first().spredsheetID }}, see Output of other nodes | n8n Docs

How to created headers with spreadsheet creation is demoed here, Issue with Google Sheets API OAuth2 Callback While Creating Sheets with Headers in n8n - #4 by ihortom.