Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Google Drive - get new filename after rename

  • September 2, 2019
  • 7 replies
  • 676 views
Martinewski
Forum|alt.badge.img

I have multiple copies of a Google Sheet (my template), with various cell protections. Those sheets are shared and used once – they are left untouched after use for archival purposes.

Whenever someone uses the file, they rename it with a customer name and address, for later searching. The renaming is done after the file is changed.

What I want to do is to have Zapier monitor file updates and send me an email or some other action, with the new filename. When Google Drive's Updated File triggers, Zapier receives the current filename (my template name).

How could I get the new file name after X minutes, using the file_id? Find File action expects a filename, not the file_id. Any ideas?


Best answer by PaulKortman

@Martinewski This is a perfect use case for a Google Apps Script. You can create a webhook (doGet) and take the file ID from the webhook URL and get the file name and return it as a result. There are a bunch of examples of this on stackoverflow etc. what follows is theory code for Google Apps script, this is not tested and may error ... but it should get you started:

function doGet(e){

  var ss=SpreadsheetApp.openById(e.parameter.sheetid);

  var ssName = ss.getName();

  var NameJSON = {'FileName':ssName, 'FileID': e.postData.sheetid}; 

  return ContentService.createTextOutput(JSON.stringify(NameJSON) ).setMimeType(ContentService.MimeType.JSON); 

}

then publish the script and it will give you a URL to call via a zapier webhook (GET) step be sure to add ?sheeetid=(the-file-id) to the end of the URL where you replace (the-file-id) with the actual ID of the file. This will return the file name to the webhook step in Zapier. .


Let me know if you need more help with this.


View original
Did this topic help you find an answer to your question?

7 replies

TheDavidJohnson

Hi @Martinewski — When someone uses the file and then renames it, are they renaming the original file? Or are they making a copy of the file, changing it, and then renaming it?


Martinewski
Forum|alt.badge.img
  • MartinewskiTinkerer
  • Author
  • Tinkerer
  • 11 replies
  • September 5, 2019

I have a Zap that creates a copy of a template file before this. So, they're actually renaming the original file (which is not my template file, but a copy of it).


Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • October 8, 2019

Hi @Martinewski! I wanted to swing back round on this to see if we can find you an answer.

Could I trouble you to clarify your last comment a little? You said that folks are renaming the original file, which is a copy, so I'm a little unclear.

Is this what's happening:

  1. You have a template file (File A)
  2. A Zap runs to make a copy of the template file (FILE 😎, that then becomes the new template
  3. The original 'template' file (FILE A) is then used as the file that's worked in
  4. When the updated file Zap runs, it's giving you the original name FILE A and not the updated name

Is that right?


TheDavidJohnson
1 person likes this
  • TheDavidJohnson
    TheDavidJohnson
TheDavidJohnson

Thanks for following up on this, @Danvers — I read the reply comment, but didn't have time that day to dig in further, and then clearly it slipped my mind. 😩

My read of this was slightly different than yours (if I'm understanding your correctly), however. I took it to mean that at Step 3, it would be FILE B that is then used as the file that's worked on. But then I got lost completely as to what was triggering the "Updated File" Zap.


Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • November 11, 2019

Hi @Martinewski! Are you still looking for some help with this? If so, could I trouble you to clarify what you are looking to do? Thanks!


Martinewski
Forum|alt.badge.img
  • MartinewskiTinkerer
  • Author
  • Tinkerer
  • 11 replies
  • November 11, 2019

Hey, sorry for the delay.

I have a Google Sheet A, which is copied to Google Sheet B. File A never changes, it's my template file. File B is created using a default filename.

When someone is going to use file B, they rename it. I need to receive this new filename.


PaulKortman
Forum|alt.badge.img+10
  • PaulKortmanZapier Expert
  • Zapier Expert
  • 469 replies
  • Answer
  • November 22, 2019

@Martinewski This is a perfect use case for a Google Apps Script. You can create a webhook (doGet) and take the file ID from the webhook URL and get the file name and return it as a result. There are a bunch of examples of this on stackoverflow etc. what follows is theory code for Google Apps script, this is not tested and may error ... but it should get you started:

function doGet(e){

  var ss=SpreadsheetApp.openById(e.parameter.sheetid);

  var ssName = ss.getName();

  var NameJSON = {'FileName':ssName, 'FileID': e.postData.sheetid}; 

  return ContentService.createTextOutput(JSON.stringify(NameJSON) ).setMimeType(ContentService.MimeType.JSON); 

}

then publish the script and it will give you a URL to call via a zapier webhook (GET) step be sure to add ?sheeetid=(the-file-id) to the end of the URL where you replace (the-file-id) with the actual ID of the file. This will return the file name to the webhook step in Zapier. .


Let me know if you need more help with this.


Need Additional help? Feel free to reach out here: https://zapier.com/experts/connex-digital/
AndrewJDavison_Luhhu
1 person likes this
  • AndrewJDavison_Luhhu
    AndrewJDavison_Luhhu

Reply


Terms & Conditions