Profile

Cover photo
Romain Vialard
Works at Revevol
Attended Euromed Management
Lives in Paris
7,640 followers|6,086,924 views
AboutPostsCollectionsPhotosYouTube+1'sReviews

Stream

Romain Vialard
moderator

News  - 
 
 
We are now using Google Sheets API v4 to update sheet filters from Yet Another Mail Merge sidebar.
It's a very nice way to quickly let the user see the most relevant info (in our case all emails that have been opened, only those that have been clicked,...)
https://sites.google.com/site/scriptsexamples/home/announcements/new-features-yamm-ui-unsubscribe-reply-to
+Riël Notermans +Bruce Mcpherson another way to use the API :)
2 comments on original post
17
1
Riël Notermans's profile photo
 
Nice work. Looks great!
Add a comment...

Romain Vialard

Shared publicly  - 
 
Easily add 'unsubscribe' links in emails sent with Yet Another Mail Merge, improved UI that highlight some hidden features, filters in the tracking report,... enjoy our new features!
https://sites.google.com/site/scriptsexamples/home/announcements/new-features-yamm-ui-unsubscribe-reply-to
8
2
Add a comment...

Romain Vialard

Shared publicly  - 
 
We have launched Awesome Table on the Google Apps Marketplace 3 weeks ago and we already have more than 1 Million users!
https://apps.google.com/marketplace/app/gljjlppdnmnaaopmnekbgldhndaggjee

Installing this app is highly recommended due to security changes on Google Sheets - as described in our article:
https://sites.google.com/site/scriptsexamples/home/announcements/awesometable-a-new-authentication-flow
So we were expecting many installations but it still feels good to see it :)
20
4
Kim Nilsson's profile photo
 
Impressive, Romain! Kudos to you and the team.
Add a comment...

Romain Vialard
moderator

News  - 
 
You can use the Marketplace API to get the list of domains who installed your add-on via the Google Apps Marketplace.
 
Installation rate, number of users, list of domains who installed your apps… Do you really know what these figures mean? How many people are really using your add-ons? Don't get it wrong! Discover what they represent in this article, to check properly how you perform on the Google Apps Marketplace.
View original post
2
Steve Webster's profile photoCarl Widigsson (Calle)'s profile photoRomain Vialard's profile photo
4 comments
 
+Carl Widigsson yes it makes a lot of sense to install an app, test it and maybe forget about it after. I just don't understand why so many admins are installing but aren't even testing :P

And yes the new Google Sites is still part of an Early Adopter Program (aka beta mode :P)
Add a comment...

Romain Vialard

Discussion  - 
 
 
Are you using Awesome Table in your intranet? Change is coming!
In August 2016, Google announced on the Apps Updates blog "enhanced third-party access protection for Google Sheets". This means that tools like Awesome Table must now ask for explicit authorization before a user can view data from Google Sheets.
1 comment on original post
5
1
Add a comment...

Romain Vialard
owner

Tips & tricks  - 
 
 
Are you using Awesome Table in your intranet? Change is coming!
In August 2016, Google announced on the Apps Updates blog "enhanced third-party access protection for Google Sheets". This means that tools like Awesome Table must now ask for explicit authorization before a user can view data from Google Sheets.
1 comment on original post
12
2
Google Bluetab's profile photoserivce AOB's profile photoFrancisca Benitez's profile photoJean-Rémi Delteil's profile photo
24 comments
 
+serivce AOB  just use an "anyone with the link" public spreadsheet as data source !

+Francisca Benitez  The app is available to Google for Work as well as Google for Education.
Add a comment...

Romain Vialard
moderator

News  - 
 
We are now using Google Sheets API v4 to update sheet filters from Yet Another Mail Merge sidebar.
It's a very nice way to quickly let the user see the most relevant info (in our case all emails that have been opened, only those that have been clicked,...)
https://sites.google.com/site/scriptsexamples/home/announcements/new-features-yamm-ui-unsubscribe-reply-to
+Riël Notermans +Bruce Mcpherson another way to use the API :)
5
3
Akshay Monga's profile photoRomain Vialard's profile photo
2 comments
 
+Akshay Monga Autocrat is mostly used to produce files (document merge) while YAMM is used for mass mailing (mail merge)
Add a comment...

Romain Vialard

Shared publicly  - 
 
Did you know you can use sheet filters to only send emails to specific people with Yet Another Mail Merge? Or that you can send different attachments to each recipients?
Most people don't as there was no UI advertising those features (you had to check our documentation to discover them). We now have an "advanced settings" UI where we will highlight all those hidden features.
16
2
Romain Vialard's profile photoAkshay Raje's profile photo
8 comments
 
Thanks +Romain Vialard!! That's really helpful!
Add a comment...

Romain Vialard
moderator

News  - 
 
 
Installation rate, number of users, list of domains who installed your apps… Do you really know what these figures mean? How many people are really using your add-ons? Don't get it wrong! Discover what they represent in this article, to check properly how you perform on the Google Apps Marketplace.
View original post
1
Add a comment...

Romain Vialard

Shared publicly  - 
 
Installation rate, number of users, list of domains who installed your apps… Do you really know what these figures mean? How many people are really using your add-ons? Don't get it wrong! Discover what they represent in this article, to check properly how you perform on the Google Apps Marketplace.
6
3
Add a comment...

Romain Vialard

Marketplace Apps  - 
 
 
Are you using Awesome Table in your intranet? Change is coming!
In August 2016, Google announced on the Apps Updates blog "enhanced third-party access protection for Google Sheets". This means that tools like Awesome Table must now ask for explicit authorization before a user can view data from Google Sheets.
1 comment on original post
1
1
Kim Nilsson's profile photoDiego Martinez's profile photo
2 comments
 
Thanks for the warning! Useful information
Add a comment...

Romain Vialard

Shared publicly  - 
 
Are you using Awesome Table in your intranet? Change is coming!
In August 2016, Google announced on the Apps Updates blog "enhanced third-party access protection for Google Sheets". This means that tools like Awesome Table must now ask for explicit authorization before a user can view data from Google Sheets.
14
13
Clinton McLeod's profile photo
 
Hi,
I've been using Awesome Table with my students to sort through large data sets. I have a question, does all the data from the Google Sheets stay in Google, or does Awesome Table collect and hold the information on the sheets? I'd love to use this to analyze student's test results, but the info needs to stay on Google's servers.
Add a comment...
Romain's Collections
Story
Tagline
Google Developer Expert, Google Top Contributor, Change Management consultant & Pre Sales Engineer
Introduction
I am mostly known for the Gmail Meter.

I used Apps Script for the first time during an internship. My teammates where wasting their time, trying to manage events registration by email. I built an event management system and realized that this script could help many people. So I published my first template. And then I published another one, and many more after. Some of them have been reused thousands of times.

I’ve done trainings and seminars on Apps Script so that more people could make more scripts and automate more tasks. But the goal is not for everybody to learn how to script. The goal is for everybody to be able to benefit from Apps Script.

I want to demonstrate that companies who have gone Google would benefit from putting together a community of scripters ready to help their fellow workers and spread the word: Don't hate. Automate.

Useful scripts:
Google Sites: Awesome Tables
Google Sites: Awesome Maps
Google Spreadsheets: Add reminders
Education
  • Euromed Management
    MSc In Management, 2008 - 2012
  • ESCEM
    2009 - 2009
Basic Information
Gender
Male
Relationship
Married
Collections Romain is following
Work
Occupation
Product manager
Employment
  • Revevol
    Product Manager, 2014 - present
    Mainly 4 products: Yet Another Mail Merge, Awesome Tables, Groups Directory & Form Publisher I work with a team of developers and focus myself on products roadmap, monetization & marketing.
  • Revevol
    Google Apps Consultant, 2010 - 2014
  • AstraZeneca
  • Valeo (Management Services)
  • Accenture
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Paris
Previously
Singapore - Marseille - Poitiers
Contact Information
Home
Email
Romain Vialard's +1's are the things they like, agree with, or want to recommend.
New interface, unsubscribe links, reply-to field and more... Enjoy new f...
sites.google.com

Yet Another Mail Merge comes with new features! You were all waiting for them: Discover the new interface, use our reply-to feature, track u

Add-ons and the Google Apps Marketplace - Google Apps Script Examples
sites.google.com

Installation rate, number of users, list of domains who installed your apps… Do you really know what these figures mean? How many people are

Customer stories - Google Apps Script Examples
sites.google.com

This site is owned & maintained by Romain Vialard, creator of Gmail Meter, Yet Another Mail Merge, Awesome Table and many other useful add-o

Awesome Table is now available in the new version of Google Sites - Goog...
sites.google.com

Starting today, all people with early access to Google Sites can easily embed Awesome Table views, using the Embed URL button.

500 000 installations and a new referral program - Google Apps Script Ex...
sites.google.com

With our new referral program, you can share a simple link by email, chat, social networks or on your blog.

Introducing bounce tracking and a brand new report interface into YAMM -...
sites.google.com

Have a look at our brand new tracking report interface! You will get an easier access to your statistics. With our powerful tracking tools,

Script Examples: Easier access to our most popular tools - Google Apps S...
sites.google.com

Explore our brand new Script Examples website, and find more easily information about our most popular add-ons: Yet Another Mail Merge, Awes

Script Examples: Easier access to our most popular tools - Google Apps S...
sites.google.com

This site is owned & maintained by Romain Vialard, creator of Gmail Meter, Yet Another Mail Merge, Awesome Table and many other useful add-o

Responsive Youtube video player for Google Sites - Google Apps Script Ex...
sites.google.com

This gadget enables you to embed responsive Youtube videos into Google Sites. The player rescales to fit any screen size!

Using an Awesome Table template has never been easier! - Google Apps Scr...
sites.google.com

Want to get started with Awesome Table? Discover our new option to copy easily a template and adapt it in order to create beautiful views in

New design and options for awesome-table.com - Google Apps Script Examples
sites.google.com

Your awesome-table.com website has been completely redesigned to make it more convenient for you! Read this article to find out the major ch

Click tracking now available in Yet Another Mail Merge - Google Apps Scr...
sites.google.com

Discover the new tracking function in Yet Another Mail Merge: You are now able to track if your recipients have clicked on the links from yo

Advanced Summary for Google Form - Google Apps Script Examples
sites.google.com

Geocode is a user-friendly add-on that turns postal addresses into GPS data. Combine Geocode and Awesome Tables to exploit the results as a

Yet Another Mail Merge, now with scheduling - Google Apps Script Examples
sites.google.com

Use the new scheduling functionality to set a specified date & time, and send your emails later! This will help you optimizing your sending

Yet Another Mail Merge, now with scheduling - Google Apps Script Examples
sites.google.com

Use the new scheduling functionality to set a specified date & time, and send your emails later! This will help you optimizing your sending

Form Publisher now available with new Google Forms (+ Templates!) - Goog...
sites.google.com

This site is owned & maintained by Romain Vialard, creator of Gmail Meter, Yet Another Mail Merge, Awesome Table and many other useful add-o

Online Book Store with filters on the left - Google Apps Script Examples
sites.google.com

Create fully responsive catalogs for e-shops, portfolios or photo galleries to display data with a user-friendly interface. This example use

New email templates available in Yet Another Mail Merge! - Google Apps S...
sites.google.com

This site is owned & maintained by Romain Vialard, creator of Gmail Meter, Yet Another Mail Merge, Awesome Table and many other useful add-o

Event Manager - Google Apps Script Examples
sites.google.com

An all-in-one tool to manage registrations to many events with Google Forms, Google Calendar and Google Sheet. Very useful to organise train

Revision of the numeric filters - Google Apps Script Examples
sites.google.com

The Awesome Table Cards view changed and offers a responsive and easily aligned layout for your data. Discover how to adapt your CSS.

Public - 2 weeks ago
reviewed 2 weeks ago
Public - a year ago
reviewed a year ago
Public - 2 years ago
reviewed 2 years ago
Public - 2 years ago
reviewed 2 years ago
22 reviews
Map
Map
Map
Public - a year ago
reviewed a year ago
Public - 2 years ago
reviewed 2 years ago
Public - 2 years ago
reviewed 2 years ago