Schedule & Send Emails Addon FAQ

What is the Schedule&Send Email Add-On for Google Sheets? >> Go to it’s landingpage to learn more.

Inhalt

General Questions

How does the “Schedule & Send Emails” Add-On work?

>> Go to the tutorial to learn more about how the addon work:

Can I save my files to Google Drive?

Yes, optionally you can save your files in Google Drive. This is especially helpful for documentation reasons.

Please note: Saving files to Google Drive is an experimental feature which will be improved in future.

To do so, check the „Save to Google Drive too [BETA]“ checkbox in the Email Settings pop-up and save your schedule.

Screenshot: Save files to Google Drive

Please note: You can’t save your files to Google Drive without scheduling your reports because you need to specify when the saving should happen.

>> Get more details in tutorial.

Export Settings

Prior: Report Settings (renamed in Version 2.76 in spring 2020)

Is it possible to give PDF files an own filename?

Yes, this feature is available since May 2018.

You can now re-name your file sheets (PDF, XLSX, ODS, CSV) as desired:

Screenshot: Rename your files

>> Get more details in tutorial.

Some of my sheets are corrupted after sending. What can I do?

Unfortunately, Google has a limit here which allows only to send a few sheets per email, all others might be corrupted.

This happends to PDF documents as well as to CSV and XLS documents.

To avoid files getting corrupted try to attach a maximum of 5 files per email: Please try how many files you can sent without getting corrupted ones. The amount might be changing depending on the content, complexity, etc.

Hint: Use the „Send email now“ button for testing. For example you can send an email to yourself with more than 5-6 files and check if the files are corrupted. If they are, you can send you another email with just 5 files and check again if they are corrupted. In this case you can be 100% sure to find the correct amount of files you can send without getting bad data.

Workaround: Use the File Merger to work around this Google limit.

Email Settings

Can I send emails to multiple recipients at once?

Yes, for sending your sheets to multiple recipients at once simply add several email addresses in the designated text field and separate them via a comma.

The same applies to CC and BCC field too.

Email Settings

Screenshot: Email Settings – Multiple Recipients

I am trying to send emails to a group email address under G-Suite. Individual emails are working fine but the group email addresses are not working, why?

Unfortunately Google has a limit here in which you might fall: You can send one email message to a maximum of 50 recipients only.

Do you have more than 50 people in your email group?

If yes, it depends on the email provider you currently use how the emails get processed.

  • If you are using a Gmail-group, Google automatically split the group emails to the different people. For example, when you have 100 people in your group, Google sends 100 emails, one for each person in the group.
  • If you are using any other provider like GoDaddy, your email is first sent to the group-email address. Second GoDaddy splits the group-email and sends one message to each person within the group. In this case you can send the email to much more than 50 people because the provider take care differently to send messages.

Can I manually send emails (without scheduling)?

Yes, you can send sheets manually to your recipients. This is helpful when you want to test your setup and send a test email to you, before you start sending it to e.g. your boss.

Furthermore this is also helpful when you often need to send Spreadsheet data manually per email but don’t want to export the files and attach it to you email client each time.

Choose the blue “Send Email Now”-Button in the Email Settings for manual sending.

Send Email now

Screenshot: Send Email now

>> Get more details in tutorial.

Can I run a Google Script before the email sends?

Currently not, because I want to make the plugin useable for everybody with very different use cases and I don’t want to make it super complicated for other users. That’s why it is mainly important to me to only add features which are of value for many people.

But feel free to send me your specific use case via the contact form: On this way I could already help several people with very specific use cases and we always came to the conclusion that the Add-On already worked fine for that.

Can I insert dynamic cell values into the email To-field?

Yes, this feature is available since January 2018 to the To, CC, BCC, email subject and email body field.

You can now dynamically add the current date or any cell value to the above fields.

>> Get more details in tutorial.

Dynamic Date Value

Use the „Current Date“ button in the Email settings to include the current date in your subject and email body:

Current Date Button Email Settings

Screenshot: Email Settings – „Current Date Button“

You can manipulate the date by increasing or decreasing the number of days via „+Value“ and „-Value“.

For example: If you want to get the date from yesterday change the date-variable to the following: {%Date-1%}

Dynamic Cell Value

Use the „Cell Value“ button in the Email settings to use the value of any cell in your spreadsheet and insert it to the subject or email body:

Email Settings Cell Value

Screenshot: Email Settings Cell Value

The value is taken from the current cursor of your current sheet. For example: I am currently in the „Features/Road Map“ sheet and my cursor is on the cell A3. So the value of this cell will be included in my email body.

The great thing of this feature is the dynamic usage: If the cell A3 dynamically changed daily, you will get the daily value of this field in your email body.

Dynamic Use Cases

In which timezone the emails got send?

Timezone is taken from the Spreadsheet settings which you can find in Google Spreadsheet under File → Settings for this spreadsheet → General.

Google Spreadsheet Add-On Timezone Setting

Screenshot: Google Spreadsheet Add-On Timezone Setting

If your emails are not correctly send, please check your timezone settings first.

For example, if you are in New York and wondering why your emails were sending 6 hours earlier than you requested, it might be because of wrong timezone settings. If this is the case, change the timezone to the correct one.

Please note: You have to re-save your schedule before the emails could be send in your choosen timezone. Otherwise the Add-On is not aware of the changes.

Is it possible to set up my own SMTP server and the sender’s own email address?

I am not sure if Google allows the connection to an own SMTP…

Nevertheless I think this is a very, very advanced feature which only a very short group of people need and will use, so I think this feature will not be incldued in the „Schedule and Send Email“ Add-On.

This is especially to reduce complexity and make the usage of the Add-On as easy as possible for everybody.

Note: If this is an essential feature for you which is absolutly needed, you can contact me via my contact form so that we find a good solution for you.

Is there an inline HTML option available?

Unfortunately not yet but this feature is already on my TODO list and will come in the next updates, hopefully soon.

As soon as I got the issue I will add the solution in the Rleases Notes of the Plugin.

Note: In the Release Notes you find all latest updates and bug fixes including a description how to solve a problem. Furthermore I listed all the upcoming features which are on my TODO liste.

Can I add images to the email body?

Yes, you can add images to the email body via the image-icon in the editor.

An pop-up opens which looks like this:

Email Settings Image

Screenshot: Email Settings Image

To insert an image you have to add the image URL in the source field of the pop-up. You can add any image formats available like .jpeg, .png, .gif.

Please note: The image URL must be public available.

Is it possible to send emails only if a cell is filled with data?

Yes, see this FAQ: Can I define a condition to trigger a schedule?

Note: Future versions will have a more convenient method to define custom conditions inside the addon without any workaround.

Schedule Settings

Is it possible to schedule more than one schedule per document?

Yes, this feature is available since May 2018 but only in the PRO version of the add-on.

With the PRO version you can set up as many schedules as you need like in this example:

Schedule Settings Summary

Is there any way to have a Monday to Friday daily schedule option (weekdays only, not at Saturday and Sunday)?

Yes, this feature is available since May 2018 and was updated in April 2020 for easier set up.

>> Get more details in tutorial.

I need to send reports every 4 hours. Is this possible?

Yes, this feature is available since May 2018 and was updated in April 2020 for easier set up.

>> Get more details in tutorial.

Is it possible to plan the schedule for a specific date in future and send it just once?

Yes, this feature is available since May 2018 and was updated in April 2020 for easier set up.

>> Get more details in tutorial:

Can I schedule my emails to a specific time like 2:30 pm?

Unfortunately it is not possible to choose a specific time like 2:30 pm to send your reports because Google didn’t allow that.

Instead it is possible to choose a specific hour of the day like from 2am to 3am or from 4am to 5am.

Is it possible to have smaller time frames for sending daily emails?

Unfortunately it is not possible to have smaller time frames for sending daily emails because Google didn’t allow that.

Instead it is possible to choose a specific hour of the day like from 2am to 3am or from 4am to 5am.

How can I disable the automatic scheduling?

To disable scheduling for one specific person, delete this person from the email addresses field. Save and schedule your settings again.

Screenshot: Delete email from To-field

To disable scheduling for all recipients, click on the “Disable Schedule” button. You will be noticed that scheduling is disabled via a red bar at the top of the add-on.

Screenshot: Disable schedule

>> Get more details in tutorial.

Where can I see and manage my scheduled emails on each spreadsheet?

Currently there is no further user interface to manage all email schedules on all your spreadsheets.

This must be done individually for each of your Spreadsheets.

Can I define a condition to trigger a schedule?

Currently there is no option for a conditional schedule.

BUT there is a very handy work around which is even better: Use a dynamic cell value as your recipient and create your own condition if the schedule will be sent or not:

  1. Create a new sheet in your spreadsheet file called „schedule-conditions“
  2. Create your condition, for example only send the schedule if cell B1 in Sheet1 is not empty: ‚Sheet1‘!B1=““
  3. Insert an IF formula in cell A1 of „schedule-conditions“: IF([your condition];“[recipient if condition is true]“;“[recipient if condition is false]“)
    1. The first parameter is your condition
    2. The second parameter are your recipients if the condition is true, or no recipient if you just add empty quotations marks.
    3. The third parameter are your recipients if the condition is false. Make sure you add quotation marks before and after it.
  4. The full formula in cell A1 could be: IF(‚Sheet1‘!B1=““;““;“myrecipient@example.com“)
    1. The condition checks if Sheet1:B1 is empty, if yes, send the scheduled email to nobody (no email address), if not, send it to myrecipient@example.com
  5. Finally add a dynamic cell value in your email settings: {%’schedule-conditions‘!A1%}
  6. Add a time schedule to check your condition e.g. daily.

In this example the addon checks daily if the cell Sheet1!B1 is empty and will either send the email to nobody (=will not send any email) or if the cell is not empty to myrecipient@example.com.

Errors

After saving the schedule, the loading icon didn’t stop loading. What can I do?

Please try to use the Schedule & Send Email Add-On in another spreadsheet first.

1) If there is the same issue, please try to de-install and re-install the plugin again.

If this also doesn’t help, have a look in your developer console and send me the error message (screenshot or text or both) via my contact form. I will then have a more detailed look on that. You will find the developer console in Google Chrome browser while pressing F12: A pop up opens where you can navigate to the second tab called „Console“. Refresh your site with F5 and have a look on the error message which appears there.

2) If the Add-On works in another Spreadsheet but not in your required, please find the hidden sheet “data-analyticskiste-emailschedule” at the bottom of your Spreadsheet, next to the first sheet name, as you can see in the following screenshot:

Google Spreadsheet Add-On Hidden Field

Screenshot: Google Spreadsheet Add-On Hidden Sheet

Open the sheet to unhide it and delete it afterwards.

Save your Email schedule again: The Add-On settings will be reset and should work now.

If not, go further with the first step above.

I can not open the addon, the loading icon spins forever.

This might be because you are logged in with multiple Google accounts in your browser.

Currently there is a bug by Google which confuses Google addons which account to use.

Just log out from all your accounts, log in with only the account you want to use the plugin with and try it again.

I lost my settings. Can I restore them?

Yes, all your settings are saved in a hidden sheet called „data-analyticskiste-emailschedule“ starting in column P:

Screenshot: Hidden settings sheet

Use the Version History of Google Sheets to get all your versions available.

To do this: Select your settings sheet and go in the menue to File –> Version History –> Show Version History.

You will find all your old versions of your settings.

Just copy the content of the sheet, close the version history (Do not restore it! It will restore all sheets.) and paste the content in your settings sheet again.

Now just refresh your browser and open „Manage Schedules“ again.

PRO

Can I transfer my PRO license to another account later?

Yes, you can transfer your license to to another account if you switch your address or if your colleague continues to manage your schedules.

Just send me a support request with the old and new Google Account Address and I will transfer it for you: Contact Support

Didn’t get an answer?

Can’t find an answer in the above FAQ list? Write me via my contact form.