Hi everyone, I'm new to Zapier, I would like to specialize in automations useful to the company. As a first requirement I have a free version of the speechnotes app, a speech to text that automatically generates and loads the generated text in txt format, with progressive numbers for each note that is created, therefore for each new note a txt file on Google Drive. Well, as a start, I would like to add the notes transcribed from Google Drive in txt format to Google Calendar quick event, then I would like to expand this process by adding a single database or "hub" of notifications with new lines for each Google Sheet note, but I'm having a lot of difficulty. Please help me because it would make my working life a lot easier. Thank you all
How do I automate adding transcribed notes from Google Drive to Google Calendar using Zapier?
Hi
Good question.
To help us have more info, please post screenshots with how your Zap steps are configured.
This is the first step to import the txt file into Google sheets, but the sheet file does not update by adding the notes imported into txt
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/cbb5dca2-bce9-453a-9610-2876d4a877da.jpg)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/56f83ecc-82ed-4cc9-b4fd-c09327ba09a9.jpg)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/a19d5f09-ac70-4327-a96a-ca992b42464e.jpg)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/e7610c44-59c0-445c-baa7-a8a96904b064.jpg)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/4313aba3-0071-4f0e-bd43-e2cdb6b13c6a.jpg)
The mapped variable for File Text has “No data”, which is hwy nothing is being updated.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/14abb1a5-1f13-49a6-ab90-74a385e5b4ab.png)
You might try turning the Zap on and trying with a text file that you know has text in it to see how it works
Many txt notes have been loaded in the specific folder that I indicated to zapier, the notes are progressive, such as "note-12.tx" "note-13.txt" because txt files are created with each new note, the settings are all correct , but the "txt file" function always reports "no data" even if the txt files are present and are loaded, but they are not reported in the google sheet which looks like the file I attach. The zap is obviously active, which is why I asked for your support. Thanks for the reply.
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/46aa2a1b-e3c7-4e71-9c84-a42bcf1ebf97.jpg)
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/9ba08716-2e86-4993-af91-f6c5d8e67f98.jpg)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.