I am creating a workflow which needs to use the transcript provided using the inbuilt transcription method as part of Google Meet. Using the transcript in Google Meet creates a Google Doc where the first tab is called ‘Notes’, containing summarised meeting notes and action points, and a second tab for ‘Transcript’, which is the full conversation and what I need for my workflow.
I need to be able to access the Transcript tab of the Google Doc but whenever I use the Google Doc n8n node, it only returns the first tab (Notes) from the document and nothing else. This is also the same if I use the ‘Simplify’ option on the Google Doc node settings.
Does anyone have a workaround or is there an obvious way to do it which I am missing?
I used a HTTP Request node in the end with the variable includeTabsContent set to TRUE. This pulls in all the tabs from the document as I wanted.
It would be nice to see this included as a toggle on the Google Doc node in the future so that we can make use of the extisting ‘Simplify’ toggle as the HTTP Request method returns a lot of unneeded data when I just need to content.
FWIW for anyone else landing here, I ended up using the Drive API’s files.export endpoint with an HTTP Request node. As the Google Docs documents.get method returns all the formatting as JSON and is a lot of data you will then have to parse to just get at the content.
e.g. GET https://www.googleapis.com/drive/v3/files/{fileId}/export?mimeType=text/plain
Setting the mimeType to text/plain returns all the Google Docs content just as text and pulls from all tabs.