Profile

Cover photo
Romain Vialard
Works at Revevol
Attended Euromed Management
Lives in Paris
6,602 followers|3,245,388 views
AboutPostsCollectionsPhotosYouTube+1'sReviews

Stream

Romain Vialard

Shared publicly  - 
 
Awesome Table templates are very powerful but might be a bit complex to use at first. So we are adding in our add-ons an easy template builder, starting with Geocode.
If you want to display a nice tooltip with useful information each time someone click on a marker in your Maps, give it a try!
Geocode is a tool that helps you get latitudes & longitudes from addresses in a Google Sheet to display them on a map you can share.
10
4
Adib Behi's profile photoAndre Charbonneau's profile photoSteve Webster's profile photoBill Martin Jr's profile photo
 
Very nice!
From"complexity" to "simplicity" -- love it.
Add a comment...

Romain Vialard

Shared publicly  - 
 
You can now use the spreadsheet functions =HYPERLINK() and =IMAGE() to add different links & images to each emails sent with Yet Another Mail Merge.
No need for HTML tags anymore! And it even works in combination with =ARRAYFORMULA()
Write your template as a draft in Gmail and insert <<markers>> to reuse data from your spreadsheet and send personalized emails.
18
4
Luciano Panepucci's profile photoAndre Charbonneau's profile photo
Add a comment...

Romain Vialard

Shared publicly  - 
 
Using Form Publisher to generate PDF from your web app. An example with the activity reports from G+ Community Meter.
11
1
Romain Vialard's profile photoAndre Charbonneau's profile photoGino Naranjo's profile photo
5 comments
 
Thanks. I'm guessing no it's not possible at the moment...
Add a comment...

Romain Vialard

Shared publicly  - 
 
Thanks to Form Publisher, you can now receive a PDF copy of your activity report in G+ Community Meter.
Simply enter your email address, and you'll receive the PDF report attached in an email.
https://chrome.google.com/webstore/detail/community-meter/gnhdadjbiljclldiiadlffpakeihdflb
https://chrome.google.com/webstore/detail/form-publisher/hgmhbdjdjoahflgfmfpjlgpplihlechm

Community Meter automatically fills a Google Form on which we've set up Form Publisher. Then the add-on grabs a spreadsheet template, fill it with the data retrieved via Google Form, convert it to a PDF and use YAMM to send it as attachment in an email. All our add-ons work very well together =)
14
6
Steve Webster's profile photoJosée Beauchesne's profile photoBrigitte Besnard's profile photoAlex Dobrov's profile photo
2 comments
 
+Steve Webster Thanks, we will write a blog post about it, if developers are interested to easily build PDF reports in their apps with Form Publisher
Add a comment...

Romain Vialard
moderator

Offtopic  - 
 
Congrats to the top contributors on this community :)
No Apps Script this time (due to lack of APIs) but we released a Chrome extension to get an activity report on any G+ community.
https://chrome.google.com/webstore/detail/community-meter/gnhdadjbiljclldiiadlffpakeihdflb
32
7
Liam Timothy's profile photoAndrés Cifuentes's profile photoСоветник Google+'s profile photoAnna N's profile photo
11 comments
 
Great idea.
Add a comment...

Romain Vialard

Shared publicly  - 
 
A new video tutorial for Form Publisher where you'll learn how you can set up a Pony rental service with Google Forms :P
(or use Form Publisher for any other workflow where you need to generate files out of form submissions)
33
14
Steve Watkins's profile photoMarcos Gomes's profile photoCamille Lapeyronie's profile photoBill Martin Jr's profile photo
3 comments
 
yo no entiendo como utilizar esta interesante herramienta, soy una persona emprendiendo un negocio, y mi interés personal es llegar a que todos conozcan mi producto, le agradecería si me puede asesorar como usar este tutorial.
 ·  Translate
Add a comment...
In his circles
76 people
Have him in circles
6,602 people
Shmuel Hierro's profile photo
Tony Di Trapani's profile photo
Phạm Việt Quốc's profile photo
lhishelo tsuhah's profile photo
Ronald Johnson's profile photo
Rolando Andorio's profile photo
Mark McLaren's profile photo
Bharath Prabhu's profile photo
Kelly Sauser's profile photo

Romain Vialard

Shared publicly  - 
 
People asked if it's possible to send different images to each recipients with YAMM. Yes! And it's quite easy to do.
In Yet Another Mail Merge, send different images to each recipients.
11
2
Pedro Márquez Gallardo's profile photoMiroslav Philipp's profile photo
Add a comment...

Romain Vialard

Shared publicly  - 
 
We have already 3 add-ons available for Google Sheets using Awesome Table to display nice views, and more to come!

Add-ons let you easily retrieve data from anywhere inside a spreadsheet and Awesome Table is perfect to display all those data retrieved. If you have Use cases that could benefit from the creation of an add-on linked to Awesome Table, don't hesitate to share!
27
12
Gino Naranjo's profile photoKassim Shahasi Shehe's profile photoLuz Pingol's profile photoTony Di's profile photo
 
Help
Add a comment...

Romain Vialard

Shared publicly  - 
 
Here's our new add-on for Google Sheet: Files Cabinet!
Use it to list all files from a folder in Google Drive, with info like the creation date, last update, and owner of each file - then add your own metadata and display all this with Awesome Table.
Quickly list all the files of a Google Drive folder in a spreadsheet, and automatically display it in an Awesome Table view.
24
9
Jane Vestil's profile photoChristopher Smy's profile photoRebecca Hirtz's profile photoColum Kellegher's profile photo
 
It's cool!!!
Add a comment...

Romain Vialard

Shared publicly  - 
 
Do you know how popular is your G+ community? Try our new Chrome extension, G+ community Meter and get an activity report over the last 30 days, with the number of posts, comments, +1, top contributors, most liked posts and more!
A Google Chrome extension that lets you analyse the content of any Google Plus community over the last 30 days to get an activity report, including the number of posts, +1, comments and a list of the top contributors.
27
12
José Pedro Paula's profile photoBen Miller's profile photoMike. Yung's profile photoAndrew Hatchett's profile photo
16 comments
 
+Romain Vialard - any idea why the report would not count posts or comments made by the community owner?
Add a comment...

Romain Vialard

Marketplace Apps  - 
 
Hi all! Here's a new Chrome extension to get an activity report on any G+ community over the last 30 days.
https://chrome.google.com/webstore/detail/community-meter/gnhdadjbiljclldiiadlffpakeihdflb
For all GAFE domains with G+ activated, we hope it will let you better evaluate how useful are communities on your domain.
7
7
Russel Dunn's profile photoJiří Leipert's profile photoKim Nilsson's profile photoJoakim Bergeå's profile photo
5 comments
 
Nice thing! Will check it out! Yes, +Kim Nilsson​, we used for almost all classes last year. Worked great. 
Add a comment...

Romain Vialard
moderator

News  - 
 
Great!
28
3
James Petersen's profile photoWeb Apps R&D's profile photoAlexander Ivanov's profile photoChristian Rojas's profile photo
6 comments
 
Wow. That'll clean up some of my larger messes!
Add a comment...
Romain's Collections
People
In his circles
76 people
Have him in circles
6,602 people
Shmuel Hierro's profile photo
Tony Di Trapani's profile photo
Phạm Việt Quốc's profile photo
lhishelo tsuhah's profile photo
Ronald Johnson's profile photo
Rolando Andorio's profile photo
Mark McLaren's profile photo
Bharath Prabhu's profile photo
Kelly Sauser's profile photo
Work
Occupation
Google Apps Consultant (Change management)
Employment
  • Revevol
    Google Apps Consultant, 2010 - present
  • 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
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
Romain Vialard's +1's are the things they like, agree with, or want to recommend.
Yet Another Mail Merge - Google Sheets add-on
chrome.google.com

Write your template as a draft in Gmail and insert &lt;&gt; to reuse data from your spreadsheet and send personalized emails.

Add different images to each email sent - Google Apps Script Examples
sites.google.com

In Yet Another Mail Merge, send different images to each recipients.

In G+ Community Meter, we are using Form Publisher to create PDF exports...
sites.google.com

Using Form Publisher to generate PDF from your web app. An example with the activity reports from G+ Community Meter.

Real-time notifications in add-ons with Firebase - Google Apps Developer...
googleappsdeveloper.blogspot.com

Editor's note: Posted by Romain Vialard, a Google Developer Expert and developer of Yet Another Mail Merge, a Google Sheets add-on. Yet Anot

Geocode - 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

A brand new Cards view! - 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.

Pull attachments from a column in the sheet - Google Apps Script Examples
sites.google.com

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

Using secured client authentication for real time read and write calls -...
sites.google.com

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

Quickstart: Read and write data in Firebase from Apps Script - Google Ap...
sites.google.com

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

Managing invoices with Form Publisher, YAMM and Awesome Table - Google A...
sites.google.com

Create PDF invoices based on a Google Docs template, store them in Drive, send them by email and easily search among thousands of invoices.

12 Free Add-ons That Take Docs And Sheets To The Next Level | The Gooru
www.thegooru.com

Add-ons are third party plugins that take your Google Apps usage to the next level. There are countless add-ons to choose from and it can be

Files cabinet - Google Apps Script Examples
sites.google.com

Use Awesome Table to list files from a Drive folder thanks to the Files Cabinet view. Useful to manage projects or different courses within

Release notes - Google Apps Script Examples
sites.google.com

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

Source - Google Apps Script Examples
sites.google.com

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

Reference - Google Apps Script Examples
sites.google.com

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

Gmail API Push notifications: don't call us, we'll call you - Google App...
googleappsdeveloper.blogspot.com

If your app needs to keep up with changes in a Gmail mailbox, whether it's new mail being received or a label being added, you are likely fa

Files Cabinet view : list files from Drive with Awesome Table - Google A...
sites.google.com

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

AODocs File Server - Google Apps Script Examples
sites.google.com

The perfect Mail Merge for Google Apps. Write your template directly in Gmail and send your emails from a Google Spreadsheet.

Public - 10 months ago
reviewed 10 months ago
Public - 10 months ago
reviewed 10 months ago
Public - a year ago
reviewed a year ago
Public - a year ago
reviewed a year ago
22 reviews
Map
Map
Map
Public - a year ago
reviewed a year ago
Public - a year ago
reviewed a year ago
Public - a year ago
reviewed a year ago