Best answer

Multiple-Step: When new row in Google Sheet -> Create new folder in Drive and Create file with date from newst row as text

  • 19 October 2022
  • 1 reply
  • 60 views

Hey everyone,

I am currently trying to create a multiple step Zap.

Trigger: New Row added to a Google Sheet

  1. Action: Create new Folder in Drive (Folder naming comes from cell in the new Google Sheet row)
  2. Action: Create a text file which contains all the data that was added to this new Google Sheet row and place it inside the newly created folder

Currently the Zap stops at the second action and returns: “File not found: Filename”.

I’ve tryed adding a delay between the first and second action but that didnt help. Seems like the folder, where the file should be placed can’t be found. Although I used the same custom naming convention when I chose the folder where the file should be placed.

 

Hope someone can help.

Thanks!

icon

Best answer by Andreasmartini 19 October 2022, 18:50

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Ok this can be closed again. Just found the solution via this Youtube Video about nested folders:

https://www.youtube.com/watch?v=jvrzCzG1RYA