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 =…