ReportLane help

1. Install and open ReportLane

1. Install ReportLane in your Google account.
2. Google shows the permissions ReportLane needs. If they come with checkboxes, tick every one. If one is left unticked, ReportLane cannot send. Why each one is needed is under Permissions.
3. Open a spreadsheet and choose Extensions → ReportLane → Open ReportLane. The ReportLane panel opens on the right, with three tabs: Reports, Reminders and Plan.

The setup is saved in the spreadsheet itself, so everyone who opens ReportLane in it sees the same reports and reminders.

2. What to send

A report sends one tab of the spreadsheet, either whole or a part of it:

• Whole tab: everything on the tab you choose.
• A range in A1 notation: A1:F30, whole columns such as A:F, rows such as 2:40, or open-ended rows such as A2:F (from row 2 down to the last row). You can name the tab in front of it, Sales!A1:F30 or 'Q4 sales'!B:D.
• A named range: type its name, such as WeeklyTotals. Named ranges are set up in Google Sheets under Data → Named ranges.

Make the first row of the range the header row. The table in the email shows it in bold, and Skip if empty counts the rows under it.

You can add as many reports as you like to a spreadsheet: a weekly PDF of one tab for your manager, a daily table of another for the team.

3. Formats

Tick one format or several. The table and a PDF together is a common choice: people read the numbers in the email and keep the file.

The table shows values the way your sheet displays them, such as $18,420 or 2026-11-16. Very long cells are cut at 500 characters. Files are named after the spreadsheet and the tab, such as Q4 sales - Weekly sales.pdf.

PDF, Excel and CSV files are made by Google, the same way File → Download makes them. If Google cannot make the file, see Troubleshooting.

4. Recipients, subject and message

• To: type the addresses, separated by commas, spaces or new lines. Free reports go to up to 3 people. With Pro, up to 50, counting To, CC and BCC together; that is Google’s limit for one email.
• CC, BCC and Reply-to (Pro): replies go to the reply-to address instead of to you.
• Subject: if you leave it empty, it is the spreadsheet name and the tab name, such as Q4 sales — Weekly sales.
• Message: a few lines above the table or the attachments. Links you type become clickable.

Subject and message can hold placeholders, filled in at each send:

Capitals and spaces inside the braces do not matter. A name ReportLane does not know is pointed out when you save. Every email ends with a link to the spreadsheet and a small “Sent with ReportLane” line.

5. Send now

Each report in the list has Send now, which sends it at once. It is free, as often as you like, for reports within the free limits. It is also the quickest way to check a report before you give it a schedule: send it to yourself first.

6. Schedules (Pro)

With Pro, a report can send itself:

• Daily, at the hour you choose: Every day at 8 AM.
• Weekly, on the days you tick: Every Mon at 8 AM, or Every weekday at 8 AM for Monday to Friday.
• Monthly, on a day from 1 to 28 or on the last day of the month: Monthly on the 1st at 8 AM.

The hour is in the spreadsheet’s time zone (File → Settings in Google Sheets), or in another time zone you choose. The report list shows when each report goes next, such as Mon, Nov 16 at 8 AM.

How it runs: one timer in your Google account wakes up every hour, looks at the reports and reminders of every spreadsheet you set up, and sends what is due. The spreadsheet does not have to be open. A send can arrive a little after the hour starts, because Google runs timers at some point within the hour.

• Saved after today’s hour? A report you schedule for 8 AM at 3 PM waits for the next 8 AM; it does not go out straight away. Use Send now for today.
• Missed runs send once. If the timer could not run for a few days, the report goes out once on the next run, not once for every missed day.
• Clock changes (daylight saving) do not skip or double a send.

7. Skip if empty, send only if changed

• Skip if empty: nothing is sent when the range has no rows with data under its header row. Good for a list of overdue items that is usually empty. Free.
• Send only if changed (Pro): a scheduled send is skipped when the values are exactly the same as at the last send. ReportLane compares a short fingerprint of the values, not a copy of them. Send now always sends.

ReportLane — Sheets to EmailEmail a sheet or range on a schedule, and send reminders from your data

See pricing

8. Reminders (Pro)

A reminder rule watches one tab and emails when a row meets it. Rules read the column names in row 1 of the tab, so give your columns clear names such as Due date, Status or Email. Reminders are checked once a day, at the hour you choose in the panel (8 AM unless you change it).

Date rules

• Choose the column with the dates and when to send: N days before the date, on the day, or N days after it (0 to 365 days). For example 3 days before — Due date.
• Optional: send only if another column is empty (such as Paid), or is not a value, “Done” unless you type another one. Finished rows then stay quiet.
• Each row and date sends once. If you change the date in the row, the new date counts as a new one. If a day was missed, a reminder is still sent up to two days late.
• Dates can be real date cells, or text such as 2026-11-20 or 11/20/2026.

Number rules

• Watch one cell, such as B2 with a total, or a column in every row, such as Stock.
• Compare with a number: ≥, ≤, = or ≠. For example Stock ≤ 10. Text such as $1,250.50, (30) or 12% is read as a number.
• A rule sends once per crossing: when a row reaches the limit, one email. While it stays there, nothing more. When it goes back over the line, the rule is ready to send again next time.

Who gets a reminder

• The addresses you type for the rule, the address in a column of the row (such as the Email column of each task), or both. A single watched cell has no row, so it needs typed addresses.
• To tell rows apart, ReportLane uses the first column, or a key column you choose, such as an invoice number. Choose one if your first column has repeated values.

What a reminder says

The subject is Reminder: … for a date rule and Alert: … for a number rule, unless you write your own. The email lists every column of the row with its value, and links to the spreadsheet. Your subject and text can use the column names as placeholders, such as {Client} or {Due date}, plus {days} (days until the date; negative after it) or {value} (the number that crossed the line), and {sheet}, {spreadsheet}, {link} and {date}.

One rule sends up to 100 emails per run; the rest follow on the next run.

9. The run log (Pro)

Switch on the ReportLane log tab in the panel to get one line per run: the time, the report or rule, the number of recipients and the result, such as sent, skipped or the error. It is an ordinary tab: sort it, filter it or delete it.

10. Google’s daily email limit, and file size

Google limits how many people one account can email in a day through scripts and add-ons: 100 recipients a day for a personal @gmail.com account and 1,500 a day for a Google Workspace™ account. Every address in To, CC and BCC counts, so a report to 5 people uses 5. The panel shows how many are left today.

When a scheduled run would go over the limit, ReportLane sends what fits, marks the rest skipped: daily email limit, and sends them on its next run after Google resets the count.

Attachments can be up to 25 MB per email in total. A PDF of a very large tab can be bigger: send a range, or the table in the email, instead.

11. Free and Pro

• Free: unlimited reports, Send now as often as you like, a tab or a range, all four formats, up to 3 recipients per report, placeholders and Skip if empty.
• Pro: $4.99 a month or $39 a year, for schedules, up to 50 recipients with CC, BCC and a reply-to address, Send only if changed, date and number reminders, and the run log tab.

Pro is bought from the panel’s Plan tab, with Paddle as our Merchant of Record. The checkout is filled in with your Google account email, and after you pay, Pro switches on by itself in the open panel, usually within a minute. Paid with a different email? Open Already paid? Activate and enter the email you used at checkout. One subscription is for one Google account.

Cancel any time from the link in your Paddle receipt, or by emailing info@bilingoplus.com. Pro then runs to the end of the period you paid for. Every charge has a 14-day refund (see refunds). If Pro ends, schedules and reminders stop, but your reports keep their settings, so they are back as they were when you renew.

12. Permissions

When you install ReportLane, Google may list each permission with a checkbox. Tick all of them. If one is left unticked, ReportLane says in its panel which one is missing and asks Google again: tick every box on Google’s screen, then close the panel and open ReportLane again.

Why “all your spreadsheets”? Google’s narrower “this spreadsheet only” permission covers the spreadsheet you are working in. Scheduled sends and reminders (Pro) run from a timer while the spreadsheet is closed, and that permission gives a timer no spreadsheet to open. So ReportLane asks for Google’s spreadsheets permission, which Google’s screen words as “See, edit, create and delete all your Google Sheets spreadsheets”. Google does not narrow it further; ReportLane’s own code does. It remembers the ID of each spreadsheet you set it up in and opens only those. It does not list, search, read or change your other spreadsheets, and it never creates or deletes a spreadsheet.

ReportLane has no Google Drive™ permission and no permission to read Gmail™. None of its permissions is a “restricted” Google permission.

13. Troubleshooting

14. Your data

ReportLane runs inside your Google account. Your sheet goes only into the emails you set up, to the people you chose; nothing from your spreadsheets is sent to BiLingoPlus. The setup is saved inside the spreadsheet, and a small record for your account (the Pro status and which spreadsheets you set up) in your Google account. Details are in the privacy policy.

15. Still stuck?

Write to info@bilingoplus.com or use the support page. Tell us the message you see in the panel or in the ReportLane log tab. Please do not send us your spreadsheet with private details in it.

ReportLane — Sheets to EmailEmail a sheet or range on a schedule, and send reminders from your data

See pricing