Profile

Cover photo
Saurabh Gupta
Works at Google
Attended New York University Stern School of Business
5,393 followers|210,314 views
AboutPostsPhotosVideosReviews
People
Have him in circles
5,393 people
David Read's profile photo
Arash Bizhan zadeh's profile photo
Lorelle VanFossen's profile photo
Troy Miller's profile photo
Justin Sze Chun Yin's profile photo
Raul Navarro's profile photo
Chris Chabot's profile photo
naga raju's profile photo
Muvana Kaliamurthy's profile photo
Education
  • New York University Stern School of Business
    MBA
  • Indian Institute of Technology Kharagpur
    B.Tech
Links
Other profiles
Work
Employment
  • Google
    present
Basic Information
Gender
Male

Stream

 
 
Just a few weeks ago, the Google Sheets team introduced greatly improved control over protected sheets and ranges. Developers have told us they're looking for the same power in Google Apps Script — after all, ever since we added data validation to the Spreadsheet service, programmatic control over protected ranges has been the most popular request on the Apps Script issue tracker.

Today, that control is yours.

With the new Protection class in the Spreadsheet service, your scripts can touch every aspect of range or sheet protection, just like in the new UI.
7 comments on original post
3
1
Andrew Stillman's profile photo
Add a comment...
 
 
I've seen many requests in the Docs Help Forum for the ability to create custom paragraph styles. As it was one of my personal top feature requests, I took some time and built a Docs add-on that (in my opinion) makes easier to manage paragraph styles, as well as create new ones (up to six, right now)

If you ever wanted something like this, give the add-on a shot :)

#googledocs   #addon   #ParagraphStyle   #googledrive   #formatting  
Manage the formatting of Doc's six default Headings and create your own extra Custom Styles
12 comments on original post
5
1
Kyle Beatty's profile photo
Add a comment...

Saurabh Gupta

Shared publicly  - 
 
 
Finally got around to publishing an add-on of my own: Crop Sheet. I'm a bit of neat freak when it comes to spreadsheets, and tens of empty columns and hundreds of empty rows always kind of bugged me. With a couple clicks you can crop your sheet to just the part that has data in it. The code is open source and hosted on GitHub: https://github.com/erickoledadevrel/crop-sheet/blob/master/Code.js
Provides the ability to quickly remove extra rows and columns from a sheet.
6 comments on original post
7
Steve Webster's profile photoCameron Roberts's profile photo
2 comments
 
simple and useful, very nice.
Add a comment...

Saurabh Gupta

Shared publicly  - 
 
Can't wait to see what get built with time triggers!!
 
Time-based triggers now in Add-ons

A few weeks ago we announced in a blog post (http://goo.gl/Js3mEH) that add-ons could start using triggers, and those of you with a keen eye may have noticed that time-based triggers were missing from the list. It took a couple of extra days to get those working right, but we're happy to announce that time-based triggers can now be used as well.

Be aware that time-based triggers in add-ons behave differently than those in regular scripts. Most notably, they can only fire at most once an hour. Take a look at our trigger documentation for the full list of caveats.
View original post
3
Romain Vialard's profile photo
Add a comment...
 
You can now build add-ons with triggers.

Check out Yet Another Mail Merge and a few others.
Developers told us they were eager to add installable Apps Script triggers to their add-ons. We're happy to announce that now you can do just that.
3
3
Vladimir Bjelakovic's profile photoVIVEK KUMAR VAISH's profile photo
Add a comment...
 
 

Take full advantage of your Google-hosted services w/ "Google Apps Script, 2 Ed." oreil.ly/Nv3Pup


View original post
5
Jacob Edward's profile photo
2 comments
 
+Saurabh Gupta 
I was wondering if there's any talk of adding Google Bookmarks as a Google Apps Scripts built-in service?  Right now they're sorta atrocious and could really use the help.
Add a comment...
Have him in circles
5,393 people
David Read's profile photo
Arash Bizhan zadeh's profile photo
Lorelle VanFossen's profile photo
Troy Miller's profile photo
Justin Sze Chun Yin's profile photo
Raul Navarro's profile photo
Chris Chabot's profile photo
naga raju's profile photo
Muvana Kaliamurthy's profile photo

Saurabh Gupta

Shared publicly  - 
 
Faster html in add-ons.
Apps Script's HTML service is a great way to easily build user interfaces for Docs, Sheets, and Forms add-ons. However, HTML service is S-L-O-W. And until today there have been quite a few restrictions on using HTML service, including the inability to use a variety of JavaScript libraries.
12
2
Josué Moëns's profile photoFilipe G L F W's profile photoJacob Jan Tuinstra's profile photoAndrew Stillman's profile photo
3 comments
 
What happens when we call IFRAME mode in non-supported browsers? Will it fall to another sandboxed mode or fail altogether?

(would test myself but am locked with my Chromebook for a few days :))
Add a comment...

Saurabh Gupta

Shared publicly  - 
 
Welcome Smartsheet to Docs and Forms add-ons store.
7
3
Scott McAllister's profile photoScott McAllister's profile photo
Add a comment...

Saurabh Gupta

Shared publicly  - 
 
Forms add-ons are now available!

If you want to develop a Forms add-ons, then please submit your request here.

https://developers.google.com/apps-script/add-ons/publish
15
4
Steve Webster's profile photoIstván Maczkó's profile photoJodi Greenspan's profile photoYaseen Mohammed's profile photo
 
Congrats!!
Add a comment...

Saurabh Gupta

Shared publicly  - 
 
 
The Merge Values add-on from AbleBits will become your best assistant for combining values from adjacent cells. You can choose if you want to merge the values horizontally, vertically or get all records from the range in one cell: http://goo.gl/GlmPf3
Use this add-on to join values in the selected rows, columns, or range and keep all original data intact.
15 comments on original post
3
Add a comment...

Saurabh Gupta

Shared publicly  - 
 
 
Flubaroo add-on for Google Sheets

A favorite among teachers, Flubaroo is now even easier to use. With add-ons in Sheets, quickly grade and analyze student performance on multiple choice and fill-in assignments. Designed by a teacher, for teachers, Flubaroo is easy to use. Try it today for your assignments, quizzes, assessments, or even an exam. http://goo.gl/DralHr
6 comments on original post
5
2
Miti Garg's profile photoRichard Vowles's profile photoMartin Hawksey's profile photo
 
quite nice...very useful
Add a comment...
Really great food with good vegetarian options also. I was really surprised by the bean curd soup... really awesome.
Food: Very GoodDecor: GoodService: Very Good
Public - 2 years ago
reviewed 2 years ago
1 review
Map
Map
Map