Learn to Magically Send Emails from Your Google Form Responses PART 2
Update: I launched www.sheetswizard.com! Come visit to try the first Custom Themes tool for Sheets: https://workspace.google.com/marketplace/app/custom_sheet_themes/773536777209
Thank you thank you thank you for showing interest in my first article on this topic, Internet friends! I have started to get a few followup emails to inquiries@maxbrawer.com and here’s the deal: I love these questions, and to make my answers as impactful as possible, I will answer them in new posts! So here we go:
Question 1: I can’t get the header/data pairs to show in the right order!
In the last post I kept it super simple and it seems like I only caused pain. So let’s talk about how to specify the order of headers and values from your data.
Option 1 is to use “values” instead of namedValues to preserve the order from Google Forms/Sheets:
However this doesn’t come with the headers, which you’ll need to grab as well. Your code would be:
function onFormSubmit(e) {
var values = e.values;
var ss = SpreadsheetApp.getActive();
var sheet =…