Your Links and Clicks in Google Sheets or Excel
A sheet link brings your LNK7 links and their clicks into a spreadsheet that keeps itself up to date. There is no add-on to install: Google Sheets and Excel read the sheet link directly. It is free, like everything else.
Making a Sheet Link
- 1 Open Integrations in the sidebar (Settings, Integrations) and find Google Sheets and Excel
- 2 Choose what the sheet should contain (below) and, if you like, give it a name
- 3 Choose Make sheet link. Confirm your password (or sign in with Google again) if it has been a while
- 4 Copy the formula it shows straight away: the sheet link is shown only once
A sheet link is for the workspace you are in when you make it. To make one for a team, switch to the team first.
What the Sheet Contains
- **Every link with its clicks**: one row per link with its short URL, destination, title, status, when it was created, its expiry and click limit, and its clicks in the last 7 days, the last 30 days and the last 90 days
- **Clicks per link per day**: one row for each day a link was clicked in the last 30 days, with the date, the link and the number of clicks. Good for charts and pivot tables
Clicks never include bots, so they match your dashboard. Only totals leave LNK7 this way: no individual visits, and nothing about the people who clicked.
In Google Sheets
- 1 Open an empty sheet and click cell A1
- 2 Paste the formula you copied. It looks like this:
=IMPORTDATA("https://app.lnk7.io/sheets/...")
Google Sheets fills the sheet and refreshes it by itself, roughly every hour. Put your charts and summaries on another tab that reads this one, so the import can always fill its own tab.
In Excel
- 1 Choose Data, then From Web
- 2 Paste the sheet link on its own (the address inside the quotes) and choose Load
- 3 To update it, choose Data, then Refresh All. In the query's properties you can make Excel refresh it every hour
Keeping It Private
Anyone who has a sheet link can see those numbers, so share the spreadsheet, not the link. A sheet link stops working straight away when:
- You revoke it on the Integrations page
- You change your password
- You leave the team it is for, are removed from it, or the team is deleted
- Your role in the team no longer includes its analytics
To keep a sheet updating after that, make a new sheet link and paste the new formula over the old one.