πŸ“ Convert Typeform data into spreadsheet

⚑ 1,945 views Β· πŸ“ File Management

Description

  1. Trigger on new Typeform form submission
  2. Get existing spreadsheet-file from NextCloud
  3. Read data from file into flow
  4. Append a new row to flow-data
  5. Convert flow-data to a spreadsheet-file
  6. Save updated spreadsheet-file to NextCloud

workflow-screenshot

Assumptions

Spreadsheet file

Named: Problems.xls in folder β€œexamples”.

Columns Names:

spreadsheetexamplefile.png

Typeform

Typeform formular with questions named exactly like the columns of the Google Sheet.

πŸ”— Nodes Used

Nextcloud, Spreadsheet File, Typeform Trigger

πŸ“₯ Import

Download workflow.json and import into n8n: Workflow menu β†’ Import from File

πŸ“– Importing guide Β· πŸ”‘ Credential setup