Skip to main content

Google Drive: Bulk Link Creation with Google Sheets

Comments

22 comments

  • Amin Lakhani

    Thanks for creating this tool! If I add columns & formulas to the same sheet (to do my own UTM construction) will the rebranding function still work?

    1
  • Joe Beda

    David -- open sourcing the code for this would allow people to build their own integrations and be a good example of how to use the rebrandly API.  I'm sure extending this to support UTM isn't a ton of work and it would let you keep the current integration super simple.

    0
  • Muzafar Chaudhry

    Hi - is there any way to see how many times a link has been clicked IN google sheets? e.g. with a formula like =rbrand_clicks(CELL)

     

    0
  • Permanently deleted user

    Hi Piers, 

    You can't do that through Google Sheets, but here's the correct info to do it via API: https://developers.rebrandly.com/reference#update-link-endpoint

    If you have any trouble, open up a support ticket on https://rebrandly.support/contact

    Colm

    0
  • Piers Jones

    Hi!

    We really need to be able to update the destination of a shortened link programatically, is this possible through Google Sheets?

    Thanks 

    0
  • Katie Nuckolls

    Hi Franz, 

    At the moment there is no way to automatically export links into a spreadsheet or into an external file. If you're interested in exporting new links you may find it helpful to use our Zapier integration: https://rebrandly.support/Zapier-Integration

    0
  • David

    Hi Joe, at the moment our engineers do not plan to include UTM. We will instead create a link import tool build inside Rebrandly. 

    0
  • gastronovi GmbH

    hi Katie, thanks for that answer, but the link does not work.

    0
  • David

    Hi Brian,
    Although there are no formal limitations in the number of links that can be created/imported with the Google Sheets plugin, it is not done to specifically support a huge quantity. We have another procedure for that and our engineers can help you directly. Please contact our support via https://rebrandly.support/contact

    0
  • jessedang

    Is there a way to generate rebrandly links in a google sheet like what I did here with the bitly access token?

    https://docs.google.com/spreadsheets/d/1eMhS2k5y7T3ZGzxmv3hXvwYIIQW-QEkqlwnUGY4LJyQ/edit?usp=sharing

    0
  • David

    Hi Muzafar, 

    For that, you need to use our Zapier integration: 
    https://www.rebrandly.com/apps/zapier

    or, if you can code, look at our API: 
    https://developers.rebrandly.com

     

     

    0
  • Muzafar Chaudhry

    Thanks for your reply - which particular part of your Zapier integration can do that?

    0
  • Katie Nuckolls

    Hi Armin, Thanks for your question! You can add additional columns with more content, but the way the sheet is set up, we will not import content from columns other than the ones that we created. You can fill additional columns with your own custom content or formulas that helps you to fill our cells though. If you need additional support here please get in touch with us here: https://rebrandly.support/contact and one of our team will happily help!

    0
  • Katie Nuckolls

    Hi Franz,
    Please try the link again. 

    0
  • gastronovi GmbH

    Is there a way to use the API in both directions? So the existing links in rebrandly read out and represent in the spreadsheet.

     

    0
  • David
    Hi @Jack,

    1. Api Key:
    Google sheet needs a place where it can read the api key, and every place/cell in the sheet is visible so, probably, there is no way to hide it.
     
    2. UTM, Tags, etc...:
    Our engineers wanted to keep the form very simple. Allowing other settings for the link could complicate it too much. We will anyway evaluate a more advanced version of this same tool. 
    0
  • David

    Rebrandly+Google sheet 

    0
  • Brian Thompson

    I have been successfully using the Google Sheets plugin. Today, as I was working with it, it just up and stopped working. Are there limitations in the number of links we can have in a Google Sheet? I attempted to generate a new API Key, remove the old one, that didn't help. I created a new sheet, that didn't help. Any ideas on what could've made it stop working? It simply will not create short URLs now when selecting the rows.

    Thanks,

    Brian

    0
  • David
    Hi @Muzar,
    Please try this specific trigger: when any link reaches a certain amount of clicks you are notified. (more info here https://zapier.com/zapbook/rebrandly)
    An example of this usage here: http://rebrandly.live/ZapAlert
    0
  • Jack Coginsky

    It could be a great addon if:

    - the api key wouldnt be visible for all the users

    - you could modify the file as you want, lets say we would like to add our own Google Analytics tags and so on, and than have the fields that allow you do the shortening.

    0
  • Joe Beda

    David -- we'd love to see UTM tags here too.  Perhaps as an option?

    0
  • Muzafar Chaudhry

    Hi David - that's very vague as there are a few Zaps for Rebrandly + Google Sheets at the link you provided.

    Zapier integration, manually set up - only gives the option to create branded links - not to fetch statistics such as clicks from links that are already shortened. This is what I am looking for. If you have a way of doing this please do let me know. Alternatively, I'd appreciate a link directly to the solution as the above is too general.

     

    Thanks!

    0

Please sign in to leave a comment.