Try

Features


  1. Record macro and perform the action on a single sheet.
  2. Edit code settings
// change these settings
var performSets = {

// change to any Spreadsheet if needed
// default: active sheet
file: SpreadsheetApp.getActive(),

// regular expression to find
// sheets for action
re: /^Sheet.*/…


Result

{ tasks: 
[ { do: true,
to: 'makhrov.max@gmail.com',
subject: 'Test #1. ⚔️💀 Kill me',
body: '<p>Yo</p>' },
{ do: true,
to: 'makhrov.max@gmail.com,max0637859167@gmail.com',
subject: 'Test #2',
body: 'Hello World' } ]
}
{ tasks: 
[ { do: true,
to: 'makhrov.max@gmail.com',
subject: 'Test #1. ⚔️💀 Kill me',
body: '<p>Yo</p>' },
{ do: true,
to: 'makhrov.max@gmail.com,max0637859167@gmail.com', …

Photo by Melany Rochester on Unsplash


  1. Copy data from all sheets
  2. Add sheet name to the data
  3. Fix column width in case sheets have different number of columns
↑ a nice picture for U. Photo by Zo Razafindramamba on Unsplash
  1. Be easy to read. Compatible with the old engine.
  2. Be easy to use. Functions have 1–2 arguments.
  3. Designed in a way to reduce calls to the server, see best practice.

  1. Superfast
  2. Easy to install
  3. Easy to maintain the code

  1. Create new Google Spreadsheet
  2. Go to menu Tools > Script editor
  3. Paste HTML file named Image2Drive.html and script file Code.gs to your script editor
  4. Save code and reload Spreadsheet.
  5. Custom menu will appear
  6. Authorize on the first run
  7. The second run will open a form.

Photo by Joel Mott on Unsplash
  1. The column with URLs
  2. The column to put the result
  3. The parsing logic. It’s a regex in my case

Max Makhrov

Google Sheets Developer, master of Online Accounting

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store