I’m trying to wrap my head around how to do the following, but really haven’t gotten very far. The goal, in a nutshell, is to have information that is submitted on a form transfer to a spreadsheet whose name matches information on the form. Here’s the details of the process I’m trying to automate:
- The following data gets added to a Google form (with a linked spreadsheet): “date”, “name”, and “description”
- The spreadsheet with the title [“name” updates] is searched for/found within a shared google drive (note: each sheet is nested within [shared drive]/[location of “name”]/“name”/“name” updates.gsheet
- Add a row to the “name” updates.gsheet, mapping the following information from the original form/spreadsheet: column A: “date”, column B: “description”
I honestly haven’t gotten very far on this. I can’t get the search function down (I’m not from a tech background, and am also new to make.com). I’m sure I’m doing this completely wrong as I can’t get Google Drive to find the folder, but here’s what I’ve got for reference (details in screenshots are slightly different than what I described above for simplicity):
Thanks for any help anyone can provide! Also, if this is NOT possible, that would be helpful too!