Upload excel template to be populated with transcribed data

Questions
1

Describe the problem/error/question

I am looking to take a transcribed audio recording and populate a template excel sheet with this information. I am having difficulty in finding where to upload an existing template excel sheet. Can someone please help me find the best way to upload an existing excel template to be populated? I have tried google sheets and excel nodes and neither seem to allow for upload of an existing spreadsheet.

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
1 Like
2

Hi @aaitken34 Welcome to the community!
personally Excel is pretty much of a unwanted pain if you are considering it, please use a google sheet saved on drive, and that way whenever someone uploads like some mp3 file which have the audio and it gets transcribed so that the AI agent can append/update rows into the sheet directly. let me know if you face some issue with that.

3

Hi @Anshul_Namdev, thank you for getting back to me. I used the google sheets node initially and didn’t see an easy way to upload an existing template? My vision means that I could be dealing with multiple different templates from different companies so an easy “upload excel sheet” is ideally what I am looking for. That way I can integrate into existing templates that companies have currently. Do you believe this is possible on n8n?

4

@aaitken34 Try using n8n form to receive your template sheets into your workflow and just use google drive to upload that sheets, and done now you can easily navigate and edit/add in that sheets with google sheet node. If things are correctly positioned , almost everything is possible in n8n like ofc not legit everything but relative tasks

5

@Anshul_Namdev thank you, I will give that a go. I am still very new to n8n so using it heavily with copilot to advise me on the next stage etc. I believe I would have a new workflow per company so it can run simultaneously using each of their different templates. Because of the workflow per company I could just store templates on google drive and receive the correct template to the correct workflow.

Once I receive the template sheets into the workflow is it possible to populate this template with the transcribed audio?

1 Like
6

@aaitken34 YES! It is very easy to do so, you just need couple of instructions for AI agent which will be AI prompt and System prompt where you will instruct AI and will also give the transcript , so yes it is really possible and do able by sheet tools.

7

@aaitken34 Recommended Solution:
Upload your Excel template to Google Drive
Go to Google Drive
Upload your Excel template file
Right-click on the file in Google Drive > Open with > Google Sheets (this converts the file)
Note the Spreadsheet ID from the Google Sheets URL
In your n8n workflow
Use Google Sheets node
Set “Append or Update”
Use Spreadsheet ID
Map your transcribed data to the correct columns
Alternative Solution: Excel (Microsoft 365)
If you want to keep this as an Excel file
Upload your Excel template to OneDrive or SharePoint
Use Microsoft Excel node in n8n
Set “Append” or “Update”
Use the name or ID of the workbook
Map your data fields

8

@Anshul_Namdev perfect, thank you for that. Will give it a go and see how I get on.

1 Like
9

Hi @Orionpax , thank you for that. I will try via the google drive method and see how I get on. Sounds easy in principal but I am definitely struggling at each stage with this so far!