If you would like to extract, clean and append formula columns to a CSV file emailed to you this add-on can come in handy. It also has a feature to set a daily time based trigger to do the job for you automatically.
The usage is very simple below are the details of each field in settings form.
Status notification email
Optional email parameter which will receive notification whether data was extracted successfully or not.
Select sheet
The sheet for appending data.
From
The CSV sender's address.
Subject
The subject of the email with CSV.
File name
CSV file name.
Select for Operation
Control whether to go ahead with the operation or not.
Do not duplicate last file
File name of last file is saved so next time when the operation is performed it does not duplicate data from last file.
Append data.
Control whether data should be appended or overwritten.
Add formula column
Control whether to add formula columns or not.
Columns
Comma separated column numbers for example 3 for C, 4 for D
Formulas
Line separated formulas for each column mentioned in column field. If the formula has
reference rows than row number must be replaced with "#" below are a couple of formula examples
=SUM(A#,B#)
=AVERAGE(A#:C#)
Filter columns
Control whether to add formula columns or not.
Columns
Comma separated columns numbers same as formula columns
Values
Line separated filter values.
Daily trigger
Check whether daily trigger is required or not.
At hour
What time should the operation start every day. Value can be from 1 to 24.
Set properties
Set's the properties.
Get Reports
Gets the data as per the settings.
Select All
Select's all sheets for operation.
Unselect All
Unselect's all sheets for operation.
Extore is a team of professionals who are passionate about creating extensions for web browsers. This devotion also gives us opportunity to appreciate work of other people. We get inspired by useful, open source extensions made by developers all over the world. Our strong belief is that one should share helpful add-ons with others. That’s why we’d like to present you our ever-growing list of favourite extensions that have inspired us. Moreover, as you probably have already learned, sometimes struggling for the best brings an end to the good. Talking about add-ons it often turns out that an upgrade is worse then previous version. Also it can become really tricky to get back to the beloved version of your favourite extension. That’s why we’re going to make not only the latest, but all versions of our favourite (and we hope yours too) add-ons available for download. No more compromises, just stick to the version you really like!
Preparing download link, please wait for seconds
Almost done...
Click to download
Error getting file. Please try again
