What This Workflow Does
This automation solves the tedious manual process of shortening URLs for marketing campaigns and social media posts. Instead of copying links between multiple tools, the workflow automatically takes any URL from your Google Sheets, processes it through dlvr.it's shortening service, then logs the shortened link back in your spreadsheet with timestamps.
Marketing teams running multiple campaigns can benefit from having all shortened links automatically organized in one searchable database. The template maintains consistency in your link tracking while eliminating repetitive manual work that often leads to errors or duplicate entries.
How It Works
1. Trigger from new spreadsheet entries
The workflow monitors your designated Google Sheet for new URL additions in a specific column. When a new link appears, it immediately initiates the shortening process.
2. URL processing with dlvr.it
Each URL gets sent to dlvr.it's API which generates a branded shortened link while preserving all original tracking parameters. The service provides analytics on clicks and geographic data.
3. Automated spreadsheet updates
The shortened URL gets written back to your Google Sheet along with metadata like creation timestamp and optional custom tags. This creates a complete audit trail of all your marketing links.
Pro tip: Add a "Campaign Name" column to your spreadsheet to automatically categorize links. You can then filter reports by campaign to compare performance.
Who This Is For
This workflow is ideal for:
- Social media managers handling multiple platforms
- Email marketing teams running newsletter campaigns
- Affiliate marketers tracking partner links
- Content creators sharing blog posts and resources
- Digital agencies managing client campaigns
What You'll Need
- A Make.com account (free tier available)
- dlvr.it account with API access
- Google Sheets edit permissions
- A spreadsheet with URLs to shorten (or create new)
Quick Setup Guide
- Duplicate the template in your Make.com account
- Connect your Google Sheets and dlvr.it accounts
- Specify which spreadsheet and column contains original URLs
- Set where shortened links should be recorded
- Test with sample URLs to verify the flow
- Activate the scenario for automatic processing
Key Benefits
Save 5+ hours weekly by eliminating manual URL shortening and logging. What typically takes minutes per link becomes instantaneous.
Reduce errors with automated tracking that prevents duplicate entries or broken links from manual copying mistakes.
Centralized link management gives your entire team access to all campaign URLs in one searchable database.
Enhanced analytics by combining dlvr.it click data with your spreadsheet for custom reporting.
Scalable solution that handles hundreds of links as easily as a few, perfect for growing marketing teams.