Help

Frequently Asked Questions

csv Exporter (PRO)

fiverr - fabiank89, #2 copy-12

The csv Exporter and csv Exporter PRO add ons are available in the Google Workspace (GSuite) Marketplace and can be found under the following links or by clicking “Add-ons > Get add-ons” in your Google Spreadsheet. 

Please make sure to reload the Google Sheet after installation of the add-on.

Yes, csv Exporter PRO has a 30-day free trial.

The free version of csv Exporter is free and always will be. So you will always be able to export csv files from Google Sheets with semicolon or any other separator. 

Enhanced functionalities like triggers, email sending or custom file name and GDrive destination are only available in the PRO version though.

In the Google Sheets add-on menu bar, you can click on “Check license status / Purchase” to check how many days are left in your 30-day free trial for csv Exporter PRO.

With csv Exporter (PRO) you can choose any delimiter/separator you like. It can be comma, semicolon or also text strings.

No, csv Exporter (PRO) only saves the settings of your last file export. That means the tab you exported and the delimiter used. For the PRO version also the file name and folder destination is saved.

Therefore, if your data changed since your last file export, you can easily export the new data with the same settings with just one click.

The folder id can be found in the URL of your Google Drive folder. The structure will be something like drive.google.com/drive/folders/folder_id. The folder id is the long string after /folders/.

You can set date and time triggers or a mix of both. The following triggers are available:

  • Minute timer: runs every one, 5, 10, 15 or 30 minutes.
  • Hour timer: runs every x hours. Can be specified by the user.
  • Day timer: runs every x days at a specified hour of the day (in 24hour format).
  • Week timer: runs every x weeks on a specific day of the week at a specified hour of the day (24hour format).
  • Month timer: Runs every month on a specific day of the month (e.g. 3rd day of every month) at a specified hour of the day (24hour format).

Triggers run automatically at the specified interval until they are deleted. To delete a trigger, go to the saved export section in your sidebar and click delete.

You can send the csv file to as many email addresses as you want. Email addresses must be split by comma. 

Most common reason why an email with the csv file is marked as spam is the email subject. Please make sure to use email subjects that are clear and precise. Empty email subjects are also often marked as spam.

You must refresh when the name of your tab or the content of your spreadsheet has changed. Just click the refresh button at the top of the add on sidebar.

Delete Empty Rows

new-icon-1

The Delete Empty Rows add-on is available in the Google Workspace (GSuite) Marketplace and can be found under the below link or by clicking “Add-ons > Get add-ons” in your Google Sheet.

Please make sure to reload the Google Sheet after installation of the add-on.

The basic functionality of Delete Empty Rows is free and always will be. 

If you want to enjoy Premium functionalities like date or time triggers or selecting all sheets at once, Delete Empty Rows costs just a single one-time fee of €3 – no subscription.

Yes, Delete Empty Rows allows for deleting empty rows or columns in just a single tab or in all tabs at once.

Delete Empty Rows can delete empty rows and columns, too.

You can set date and time triggers or a mix of both. The following triggers are available:

  • Minute timer: runs every one, 5, 10, 15 or 30 minutes.
  • Hour timer: runs every x hours. Can be specified by the user.
  • Day timer: runs every x days at a specified hour of the day (in 24hour format).
  • Week timer: runs every x weeks on a specific day of the week at a specified hour of the day (24hour format).
  • Month timer: Runs every month on a specific day of the month (e.g. 3rd day of every month) at a specified hour of the day (24hour format).

Delete Empty Rows allows setting up to 5 automations that run at intervals specified by you. 

You can find more about date & time triggers in the Help section above.

Triggers run automatically at the specified interval until they are deleted. To delete a trigger automation, go to the trigger section in your sidebar and click delete.

Delete Empty Rows does not use or store the content of your Google Spreadsheet. The add-on only saves the settings of your automation (if you set any). That means it will only save the tab and if you want to delete empty rows or columns.

Google Sheets

icons8-google-sheets-240

Time-driven triggers can be used to run a Sheet script function periodically or at a specific date and time in the future. Use cases for time-driven triggers might be some of the following:

  • Automatically sending a report to your team every Friday at 10 a.m.

  • Sending yourself an email on the 1st January every year to remind yourself to set some New Year’s Resolutions.

 

There are six types of Time-driven triggers in Google Sheets

(1) Specific date and time

Runs a script function at a specific date and time in the future. The standard format for setting such a trigger is YYYY-MM-DD HH:MM  and in the GMT-07:00 timezone (which is the Pacific Daylight Time or PDT). However, the time and date format can also be changed with a script function. The hours and minutes must be specified using the 24-hour clock convention.

(2) Minutes timer

Use this option to run a script function every minute or once every N minutes (where N can be 5, 10, 15 or 30). These minute options are pre-specified by Google. Other minute options are not possible.

(3) Hour timer

Use this option to run a script function every hour or once every N hours (where N can be any integer number).

(4) Day timer

Use this option to run a script function every day at a specific time. You cannot choose the very exact time but you can select time intervals that are an hour long. Google will then randomly pick a time within this interval and the function will be run daily at this time. So if you set the time to 14.00 o’clock (note also 24-hour clock convention here) the script will run at some random time between 14.00h and 15.00h. So it can be 14.01h or 14.38h or any other time in between this interval.

(5) Week timer

Use this option to select the day of the week (Monday to Sunday) and the time on that day when your script function should run. For example, you can make it run every Monday between 8 a.m. and 9 a.m. Note here that it is not possible to set a specific time but the above mentioned time interval is also applicable here.

(6) Month timer

Use this option to select the day of the month and the time on that day when your script function should run. For example, you can make it run on the 5th of every month between 17.00h and 18.00h. The hour interval rule also applies here.

Unfortunately, Google only allows to export csv files separated by comma. If you need to export csv files from GSheets with a different separator, try out our free add-on csv Exporter.

Deleting empty rows or columns in GSheets requires some manual steps. The easiest way is to use our add-on Delete Empty Rows.

Google does not allow setting a very specific time for triggers. If you set a trigger to 8 a.m. the trigger will run any time between 8 a.m. and 9 a.m. It is unfortunately not possible to set more precise time triggers. The exact minute and second your trigger fires will be completely random within this one-hour interval.

Google Sheets is great but it is not perfect. The functions that the GSuite community most often names as missing from GSheets can be found under the following link. Luckily, some of the missing functions can be solved with some turnarounds.

Microsoft Excel is the most used spreadsheet program in the world. Rooted in the Microsoft Office suite, most corporates and individuals use it. Google has built its GSuite services like Mail or Sheets to challenge the predominance of Microsoft Office and Excel in particular.

But Excel is still dominant especially in the business world. One reason for this is simply the time in the market. Microsoft Excel has been available for decades, whereas Google Sheets is relatively new. 

However, there are also some important differences in terms of functionality between Excel and Google Sheets. Some popular functions from Excel are simply missing in Google Sheets giving Microsoft Excel also a use case advantage.

Some of the reasons why Excel is still more used than Google Sheets can be found under the following link:

OptaKey

cropped-fiverr-fabiank89-14-2.png

You can contact us either via support@optakey.com or via our contact form here.

The terms and conditions can be found here.

The privacy policy can be found here.

If you want to cancel your purchase of any of our products, you have a 14-day right of revocation starting on the day when your purchase is confirmed. You do not have to state any reasons for this.

Please refer to our right of revocation under the following link:

Yes, our official LinkedIn page can be found under the following link: