The Scenario
You're the content marketing lead. Five campaign links went live over the past month and you need to show click trends — daily, for each link — in a chart for the executive sync tomorrow at 9 AM. The chart template is already in the sheet. It just needs the data underneath it.
The bad version:
- Open Linkly, navigate to the first link, open the analytics panel, find the date range selector, pull daily data for the past 30 days
- Click "export" if there is one — there isn't, so you manually read each day's number off the chart and type it into the sheet
- Repeat for four more links, spending 90 minutes on data entry while your actual analysis work sits untouched
You were supposed to be writing the exec narrative, not copying numbers off a line chart at midnight.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the link IDs you have, calls Linkly for the time-series data, and writes one row per day per link — exactly the structure a chart needs.
Get daily click counts for Linkly link ID abc123 from 2024-01-01 to 2024-01-31 and write the date and click count into columns A and B
What You Get
- Columns A and B fill with one row per day: date in column A (YYYY-MM-DD format), click count in column B
- Days with zero clicks are included as zero rather than omitted — so your chart has a continuous x-axis
- The date range is exactly what you specified: no extra rows, no missing days
- If the link ID is invalid or the date range returns no data, column B gets a note on row 2 rather than silently producing a blank range
What If the Data Is Not Quite Ready
You have five link IDs and need all of them in one table
Column A has five Linkly link IDs. You need one table with a date column and one column per link, labeled by ID.
Pull daily click data for each Linkly link ID in column A for the last 30 days and write one row per day with the date in column B and click counts for each link in columns C through G, using the link ID as the column header
The date range needs to match a campaign start date from another column
Each link in column A has a campaign start date in column B. You want data from that start date through today for each link.
For each Linkly link ID in column A, pull daily click data starting from the date in column B through today and write the results into a new sheet called "Time-Series" — one block per link, separated by a blank row, with the link ID as a header
You want only weekdays, not the full calendar
Weekend traffic is noise for a B2B product. Strip it from the chart data.
Pull daily click counts for Linkly link ID abc123 for the last 30 days, filter out Saturdays and Sundays, and write the date and click count into columns A and B
Pull all five links, filter weekdays only, normalize dates, and add a total column
Pull daily click data for each Linkly link ID in column A for the last 30 days, filter out weekends, write one row per day with the date in column B and click counts in columns C through G using the link IDs as headers, and add a TOTAL column in column H summing across all links — format dates as YYYY-MM-DD
The chart template sitting in the sheet can reference those columns directly.
Try It
Open the sheet where your chart lives, paste in your Linkly link IDs, then Get the 7-day free trial of SheetXAI and ask it to pull the time-series data. If you need aggregate totals by country instead of day-by-day trends, see pulling click analytics by country or platform. The hub overview has the full list of Linkly + Google Sheets workflows.