Linkly Google Sheets Integration

Linkly provides live feeds for getting traffic data into Google Sheets.

The live feeds update approximately once every 24 hours.

Live Google Sheets Feeds

On every traffic report, you’ll find a live sheets feed link:

Google Sheets traffic data feeds
Google Sheets traffic data feeds

When you click this link, a formula you can paste into your spreadsheet will copied to the clipboard. Just paste it into a blank sheet, and you’ll see the data appear in a moment.

Questions about Google Sheets Feeds

Why do I see a column of numbers where I should see dates?

Highlight the column of numbers and select Format -> Number -> Date in the Google Sheets menu.

My feed is static, how can I make it update for new data?

You can modify the start & end URL parameters in your spreadsheet in order to get the data for the period you want.

Why isn't my feed updating?

We update the feeds immediately, but Google only process them once every 24 hours or so. There isn't currently a way to change that.

What about my API key?

Your feed URL contains your API key, which allows people who have it to access your account data, so be cautious about who can edit the spreadsheet.

Track 1000 monthly clicks with all features included.

No credit card required