# Rename google drive files within a table **URL:** \ **Category:** Ask the Community\ **Created:** [July 16, 2023, 12:34pm UTC](https://connect.superhuman.com/t/rename-google-drive-files-within-a-table/41348 "2023-07-16T12:34:27Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Eduardo\_Nunes](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/eduardo_nunes/32/33149_2.png) [@Eduardo\_Nunes](https://connect.superhuman.com/u/Eduardo_Nunes)\ **Post date:** [July 16, 2023, 12:34pm UTC](https://connect.superhuman.com/t/rename-google-drive-files-within-a-table/41348/1 "2023-07-16T12:34:27Z")
I’ve been needing to change name of many files. I do use the google drive pack, but it would be very valuable if I could change the old names of files to a new name from the same row of a table. I’ve searched on google drive pack, but did not find a formula to change name of file. 🥲 PS: Currently, I am using Coda AI to find info on a pdf, then I use such info to make a new file name. That is working flawlessly, but as said I could not find a work around to automate renaming the file. Any one has a solution for that? ---
**Author:** ![Jannis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jannis/32/34283_2.png) [@Jannis](https://connect.superhuman.com/u/Jannis)\ **Post date:** [July 16, 2023, 12:54pm UTC](https://connect.superhuman.com/t/rename-google-drive-files-within-a-table/41348/2 "2023-07-16T12:54:16Z")
Hi @Eduardo_Nunes, editing is currently not supported, you can only get data - at least with the [Google Drive Pack](https://coda.io/packs/google-drive-1059). If it’s really important to you, you can try a third party app like Zapier, make or n8n or the Coda-API. Sincerely Jannis ---
**Author:** ![Scott\_Collier-Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_collier-weir/32/29677_2.png) [@Scott\_Collier-Weir](https://connect.superhuman.com/u/Scott_Collier-Weir)\ **Post date:** [July 16, 2023, 2:05pm UTC](https://connect.superhuman.com/t/rename-google-drive-files-within-a-table/41348/3 "2023-07-16T14:05:43Z")
Hey there! Another thing you could do is use a simple apps script connected to your coda doc via a button And rename files that way! Apps script is a perfect use case for this and need like this is why I made this video This video specifically shows how to use apps script to send gmail with files/attachments but you could deploy an even simpler script to rename a file You could even use ChatGPT to help write the specific script you need Let me know if you have questions! You could be up and running in 15 min [![](https://global.discourse-cdn.com/coda1/original/3X/c/9/c93578b5f7ab6ff9fc385eee02c0d54bc956afb4.jpeg "Send Gmail from Coda w/ Attachments or Files") ](https://www.youtube.com/watch?v=huSGofcA2Dk) ---
**Author:** ![Eduardo\_Nunes](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/eduardo_nunes/32/33149_2.png) [@Eduardo\_Nunes](https://connect.superhuman.com/u/Eduardo_Nunes)\ **Post date:** [July 16, 2023, 5:42pm UTC](https://connect.superhuman.com/t/rename-google-drive-files-within-a-table/41348/4 "2023-07-16T17:42:18Z")
Thanks @Jannis , nor Make or Zappier has the option to rename a file. I might try [Axiom.io](http://Axiom.io) on Monday, as it can access google drive via web and coda via web. Not the best solution, but it should get the work done. ---
**Author:** ![Eduardo\_Nunes](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/eduardo_nunes/32/33149_2.png) [@Eduardo\_Nunes](https://connect.superhuman.com/u/Eduardo_Nunes)\ **Post date:** [July 16, 2023, 5:47pm UTC](https://connect.superhuman.com/t/rename-google-drive-files-within-a-table/41348/5 "2023-07-16T17:47:17Z")
I’ve got this from Chatgpt: > function changeFileName() { > var folderPath = “G:/Meu Drive/1. LeveAgro/3. Contabilidade/NFs ENTRADA/2023/Execução Prosollo/Julho/NFs com Guia de ICMS Não Emitidas”; > var newFileName = “New File Name”; > > // Get the folder by its path > var folder = DriveApp.getFolderByPath(folderPath); > > // Get all the files in the folder > var files = folder.getFiles(); > > // Iterate over the files and change the name > while (files.hasNext()) { > var file = files.next(); > file.setName(newFileName); > } > } I have absolutely no knowledge of coding… I love your suggestion on the email, as it is a simple copy and past that I will be able to do - I do actually have a use case for it already. However, adapting it to renaming a file that changes the name using a anme from each row in a table of coda. I am not sure I will be able to do it - limited skills by now. LOL Thanks for the suggestion though! ---
**Author:** ![Jannis](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jannis/32/34283_2.png) [@Jannis](https://connect.superhuman.com/u/Jannis)\ **Post date:** [July 16, 2023, 9:49pm UTC](https://connect.superhuman.com/t/rename-google-drive-files-within-a-table/41348/6 "2023-07-16T21:49:32Z")
Okay 👍 Sincerely, Jannis ---
**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\ **Post date:** [October 14, 2023, 9:50pm UTC](https://connect.superhuman.com/t/rename-google-drive-files-within-a-table/41348/7 "2023-10-14T21:50:11Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.