DEV Community

Mattt.Earth
Mattt.Earth

Posted on

Solution for bulk, short to long URL, redirects

Hi,

Please suggest any solutions how I may achieve bulk redirects

  1. I wish to use a Google sheet containing two columns. One column for the short Source URL, and the second for a long Destination URL. Each row would contain a separate individual website redirect.

  2. The redirect solution will read the spreadsheet and when a person visits the short URL, they will be redirected to the long URL.

  3. As I create new (or edit existing) rows in the spreadsheet, the solution will always use the current spreadsheet data.

BACKGROUND

Over the years I've used a variety of solutions to achieve short to long URL redirects, for example redirecting from
mattt.in/dirtbikes to https://youtube.com/playlist?list=PL4Ww-96zz93LzZD-rovxt1D3SAjJopyjh&si=bdO_aJ6NexZBV-_R
The short URL is easier and better for sharing. I currently maintain a manual list of shares at mattt.in/jump

Currently, I'm using BunnyCDN redirects. This works well, but the number of redirects is limited to 49. In the past, working with developers we've created services which are part of a bigger solution built on Ruby on Rails, SvelteKit, and PHP/Symfony. My requirement now is for a personal solution.

REQUIREMENTS

  • The solution will redirect from one short URL domain with many URLs (mattt.in/123, mattt.in/456), with each short URL redirecting to another website/URI.
  • Solution must support hundreds or thousands of redirects.
  • Use of Google spreadsheet is preferred for easy maintenance.
  • The redirect will preferably create a 301 or a 302 response code. This is favourable for Search Engines, but not critical.
  • Must be low cost or free.
  • Must be self created and maintained. Not a managed redirect service (e.g. bit.ly).
  • My coding skills are fairly basic. I can typically cobble together solutions from other peoples open source code. I'm familiar with many infrastructure technologies DNS/CDNs/Web Servers/Cloud etc.

Thank you

Mattt

Update after posting: I see the mattt.in URLs are not treated here at dev.to as hyperlinks. Does anyone know why [perhaps YouTube is trusted as they are working. Also, this is my first post here in a long time. Perhaps my account is unrusted]?

My personal website mattt.earth is pretty short, but on realising .earth hyperlinks have limited or no support in Signal, iMessage, and WhatsApp, I started using the mattt.in domain for redirects. This strategy may be thwarted?? I also own guya.me and could use that.
Thanks

Top comments (0)