Is there a Google app script that lets me do a mail merge from a spreadsheet where the output is a single document rather than separate documents (a new page for every row in the spreadsheet)?
AutoCrat works extremely well but it separates all the mail merges into different documents. I hope this question make sense.
He is married to his favorite person, and loves his three children quite a little bit (aged 10, 15 and 17). He is passionate about authentic learning, technology with purpose, and creating at least one new thing every day. In short, he teaches, and learns. A lot.
I haven’t seen one…but I have a similar request. I’d like to cycle through the Sheet and merge the rows that share a common cell value and email them in one message to an identified person.
OR an upgrade to Autocrat to merge an array into the doc.
The closest may be sheetSpider. Create new Sheets based on an ID and share w/ the appropriate users.
I haven’t seen one…but I have a similar request. I’d like to cycle through the Sheet and merge the rows that share a common cell value and email them in one message to an identified person.
OR an upgrade to Autocrat to merge an array into the doc.
The closest may be sheetSpider. Create new Sheets based on an ID and share w/ the appropriate users.
I haven’t seen one…but I have a similar request. I’d like to cycle through the Sheet and merge the rows that share a common cell value and email them in one message to an identified person.
OR an upgrade to Autocrat to merge an array into the doc.
The closest may be sheetSpider. Create new Sheets based on an ID and share w/ the appropriate users.
I thought docappender did you are looking for, but since Jay Atwood says he doesn’t know of one and I learned about docappender from him, I guess I’m wrong.
I thought docappender did you are looking for, but since Jay Atwood says he doesn’t know of one and I learned about docappender from him, I guess I’m wrong.
I thought docappender did you are looking for, but since Jay Atwood says he doesn’t know of one and I learned about docappender from him, I guess I’m wrong.
I think that docAppender only works onFormSubmit. I couldn’t get it to work with existing data. I don’t think there’s a manual trigger for it…but Andrew Stillman might correct me on that. #featureRequest
I think that docAppender only works onFormSubmit. I couldn’t get it to work with existing data. I don’t think there’s a manual trigger for it…but Andrew Stillman might correct me on that. #featureRequest
I think that docAppender only works onFormSubmit. I couldn’t get it to work with existing data. I don’t think there’s a manual trigger for it…but Andrew Stillman might correct me on that. #featureRequest
Ben Wilkoff The one that Jay used looked like a blank document, but once folks submitted information, the submissions showed up in a table. I’m not sure if a table is the only option or not . . .
Ben Wilkoff The one that Jay used looked like a blank document, but once folks submitted information, the submissions showed up in a table. I’m not sure if a table is the only option or not . . .
Ben Wilkoff The one that Jay used looked like a blank document, but once folks submitted information, the submissions showed up in a table. I’m not sure if a table is the only option or not . . .
True that docAppender has very limited format options and doesn’t use a template. What you’re describing is definitely doable, but I’m not aware of any existing projects that accomplish this.
True that docAppender has very limited format options and doesn’t use a template. What you’re describing is definitely doable, but I’m not aware of any existing projects that accomplish this.
True that docAppender has very limited format options and doesn’t use a template. What you’re describing is definitely doable, but I’m not aware of any existing projects that accomplish this.
Jay Atwood what you’re describing is possible via formMule if you use the rangetotable function in conjunction with the filter function. This will produce an HTML table in a single cell in the row that can be merged to email body. Currently not possible via autoCrat.
Jay Atwood what you’re describing is possible via formMule if you use the rangetotable function in conjunction with the filter function. This will produce an HTML table in a single cell in the row that can be merged to email body. Currently not possible via autoCrat.
Jay Atwood what you’re describing is possible via formMule if you use the rangetotable function in conjunction with the filter function. This will produce an HTML table in a single cell in the row that can be merged to email body. Currently not possible via autoCrat.
Bjorn Behrendt I was definitely tempted to try this. Probably wouldn’t be too difficult to modify the script to do this. The issue is that the way the tags are found and replaced is a global operation, so the merge would have to occur in a temporary document and then the body of that document would have to be appended to the existing document.
Bjorn Behrendt I was definitely tempted to try this. Probably wouldn’t be too difficult to modify the script to do this. The issue is that the way the tags are found and replaced is a global operation, so the merge would have to occur in a temporary document and then the body of that document would have to be appended to the existing document.
Bjorn Behrendt I was definitely tempted to try this. Probably wouldn’t be too difficult to modify the script to do this. The issue is that the way the tags are found and replaced is a global operation, so the merge would have to occur in a temporary document and then the body of that document would have to be appended to the existing document.
It shouldn’t matter if you add 1 page at a time to the document since the tags from the previous line would already have been changed, thus leaving only one set of tags to change.
It shouldn’t matter if you add 1 page at a time to the document since the tags from the previous line would already have been changed, thus leaving only one set of tags to change.
It shouldn’t matter if you add 1 page at a time to the document since the tags from the previous line would already have been changed, thus leaving only one set of tags to change.
This shows an amazing amount of promise. I was trying to figure out a workaround involving IFTTT and FormMule. Not perfect with formatting, but it does create a single document. I’m more interested in the solution you have laid out however.
This shows an amazing amount of promise. I was trying to figure out a workaround involving IFTTT and FormMule. Not perfect with formatting, but it does create a single document. I’m more interested in the solution you have laid out however.
This shows an amazing amount of promise. I was trying to figure out a workaround involving IFTTT and FormMule. Not perfect with formatting, but it does create a single document. I’m more interested in the solution you have laid out however.
I see, that’s a good point. I’m moving house soon so it might be a few weeks until I can look into it but I imagine it wouldn’t be too difficult to solve. If you see any other bugs please let me know.
I see, that’s a good point. I’m moving house soon so it might be a few weeks until I can look into it but I imagine it wouldn’t be too difficult to solve. If you see any other bugs please let me know.
I see, that’s a good point. I’m moving house soon so it might be a few weeks until I can look into it but I imagine it wouldn’t be too difficult to solve. If you see any other bugs please let me know.
Looking at it again, it seems I did consider spaces and I tested with a space in the column heading and in the rows of data, both seem to be handled ok. Can you share your Sheet?
As for the cursor position – it was really easy to update that so you can add “tags” wherever your cursor is.
Looking at it again, it seems I did consider spaces and I tested with a space in the column heading and in the rows of data, both seem to be handled ok. Can you share your Sheet?
As for the cursor position – it was really easy to update that so you can add “tags” wherever your cursor is.
Looking at it again, it seems I did consider spaces and I tested with a space in the column heading and in the rows of data, both seem to be handled ok. Can you share your Sheet?
As for the cursor position – it was really easy to update that so you can add “tags” wherever your cursor is.
Alright, I think I isolated it. It looks like tags with a question mark in them aren’t coming through correctly. I’m going to play around to see if I can figure out how to make them work, but I think that is the issue.
Alright, I think I isolated it. It looks like tags with a question mark in them aren’t coming through correctly. I’m going to play around to see if I can figure out how to make them work, but I think that is the issue.
Alright, I think I isolated it. It looks like tags with a question mark in them aren’t coming through correctly. I’m going to play around to see if I can figure out how to make them work, but I think that is the issue.
That works for question marks at the end of the tag, but not in the middle. It also seems to have a hard time with Parenthesis and other special characters like / or *.
That works for question marks at the end of the tag, but not in the middle. It also seems to have a hard time with Parenthesis and other special characters like / or *.
That works for question marks at the end of the tag, but not in the middle. It also seems to have a hard time with Parenthesis and other special characters like / or *.
I haven’t seen one…but I have a similar request. I’d like to cycle through the Sheet and merge the rows that share a common cell value and email them in one message to an identified person.
OR an upgrade to Autocrat to merge an array into the doc.
The closest may be sheetSpider. Create new Sheets based on an ID and share w/ the appropriate users.
I haven’t seen one…but I have a similar request. I’d like to cycle through the Sheet and merge the rows that share a common cell value and email them in one message to an identified person.
OR an upgrade to Autocrat to merge an array into the doc.
The closest may be sheetSpider. Create new Sheets based on an ID and share w/ the appropriate users.
I haven’t seen one…but I have a similar request. I’d like to cycle through the Sheet and merge the rows that share a common cell value and email them in one message to an identified person.
OR an upgrade to Autocrat to merge an array into the doc.
The closest may be sheetSpider. Create new Sheets based on an ID and share w/ the appropriate users.
I thought docappender did you are looking for, but since Jay Atwood says he doesn’t know of one and I learned about docappender from him, I guess I’m wrong.
I thought docappender did you are looking for, but since Jay Atwood says he doesn’t know of one and I learned about docappender from him, I guess I’m wrong.
I thought docappender did you are looking for, but since Jay Atwood says he doesn’t know of one and I learned about docappender from him, I guess I’m wrong.
I think that docAppender only works onFormSubmit. I couldn’t get it to work with existing data. I don’t think there’s a manual trigger for it…but Andrew Stillman might correct me on that. #featureRequest
I think that docAppender only works onFormSubmit. I couldn’t get it to work with existing data. I don’t think there’s a manual trigger for it…but Andrew Stillman might correct me on that. #featureRequest
I think that docAppender only works onFormSubmit. I couldn’t get it to work with existing data. I don’t think there’s a manual trigger for it…but Andrew Stillman might correct me on that. #featureRequest
I have taken a look at DocAppender in the past, but does it allow you to use a custom format like a mail merge?
I have taken a look at DocAppender in the past, but does it allow you to use a custom format like a mail merge?
I have taken a look at DocAppender in the past, but does it allow you to use a custom format like a mail merge?
Ben Wilkoff The one that Jay used looked like a blank document, but once folks submitted information, the submissions showed up in a table. I’m not sure if a table is the only option or not . . .
Ben Wilkoff The one that Jay used looked like a blank document, but once folks submitted information, the submissions showed up in a table. I’m not sure if a table is the only option or not . . .
Ben Wilkoff The one that Jay used looked like a blank document, but once folks submitted information, the submissions showed up in a table. I’m not sure if a table is the only option or not . . .
True that docAppender has very limited format options and doesn’t use a template. What you’re describing is definitely doable, but I’m not aware of any existing projects that accomplish this.
True that docAppender has very limited format options and doesn’t use a template. What you’re describing is definitely doable, but I’m not aware of any existing projects that accomplish this.
True that docAppender has very limited format options and doesn’t use a template. What you’re describing is definitely doable, but I’m not aware of any existing projects that accomplish this.
Jay Atwood what you’re describing is possible via formMule if you use the rangetotable function in conjunction with the filter function. This will produce an HTML table in a single cell in the row that can be merged to email body. Currently not possible via autoCrat.
Jay Atwood what you’re describing is possible via formMule if you use the rangetotable function in conjunction with the filter function. This will produce an HTML table in a single cell in the row that can be merged to email body. Currently not possible via autoCrat.
Jay Atwood what you’re describing is possible via formMule if you use the rangetotable function in conjunction with the filter function. This will produce an HTML table in a single cell in the row that can be merged to email body. Currently not possible via autoCrat.
BTW rangetotable is a custom function that comes with formMule
BTW rangetotable is a custom function that comes with formMule
BTW rangetotable is a custom function that comes with formMule
Sweet. I’ll explore that.
Sweet. I’ll explore that.
Sweet. I’ll explore that.
Andrew Stillman how hard would it be to have the choice of having autocrate append vs create new?
Andrew Stillman how hard would it be to have the choice of having autocrate append vs create new?
Andrew Stillman how hard would it be to have the choice of having autocrate append vs create new?
Bjorn Behrendt I was definitely tempted to try this. Probably wouldn’t be too difficult to modify the script to do this. The issue is that the way the tags are found and replaced is a global operation, so the merge would have to occur in a temporary document and then the body of that document would have to be appended to the existing document.
Bjorn Behrendt I was definitely tempted to try this. Probably wouldn’t be too difficult to modify the script to do this. The issue is that the way the tags are found and replaced is a global operation, so the merge would have to occur in a temporary document and then the body of that document would have to be appended to the existing document.
Bjorn Behrendt I was definitely tempted to try this. Probably wouldn’t be too difficult to modify the script to do this. The issue is that the way the tags are found and replaced is a global operation, so the merge would have to occur in a temporary document and then the body of that document would have to be appended to the existing document.
So currently the steps Autocrate takes?
1. Create a copy of the template with tags
2. Read line 1 from sheet
3. replace tags
4. Repeat 1-3 with next line
It shouldn’t matter if you add 1 page at a time to the document since the tags from the previous line would already have been changed, thus leaving only one set of tags to change.
Append steps
1. Create a copy of the template with tags
2. Read line 1 from sheet
3. replace tags
4. Append to doc created in step 1.
5. Read next line
6. Replace Tags
7. Repeat 4-6
So currently the steps Autocrate takes?
1. Create a copy of the template with tags
2. Read line 1 from sheet
3. replace tags
4. Repeat 1-3 with next line
It shouldn’t matter if you add 1 page at a time to the document since the tags from the previous line would already have been changed, thus leaving only one set of tags to change.
Append steps
1. Create a copy of the template with tags
2. Read line 1 from sheet
3. replace tags
4. Append to doc created in step 1.
5. Read next line
6. Replace Tags
7. Repeat 4-6
So currently the steps Autocrate takes?
1. Create a copy of the template with tags
2. Read line 1 from sheet
3. replace tags
4. Repeat 1-3 with next line
It shouldn’t matter if you add 1 page at a time to the document since the tags from the previous line would already have been changed, thus leaving only one set of tags to change.
Append steps
1. Create a copy of the template with tags
2. Read line 1 from sheet
3. replace tags
4. Append to doc created in step 1.
5. Read next line
6. Replace Tags
7. Repeat 4-6
This shows an amazing amount of promise. I was trying to figure out a workaround involving IFTTT and FormMule. Not perfect with formatting, but it does create a single document. I’m more interested in the solution you have laid out however.
This shows an amazing amount of promise. I was trying to figure out a workaround involving IFTTT and FormMule. Not perfect with formatting, but it does create a single document. I’m more interested in the solution you have laid out however.
This shows an amazing amount of promise. I was trying to figure out a workaround involving IFTTT and FormMule. Not perfect with formatting, but it does create a single document. I’m more interested in the solution you have laid out however.
Ben Wilkoff, I have been working on an app in Docs that can do what you describe. If you can share your email I will share the doc with you.
Ben Wilkoff, I have been working on an app in Docs that can do what you describe. If you can share your email I will share the doc with you.
Ben Wilkoff, I have been working on an app in Docs that can do what you describe. If you can share your email I will share the doc with you.
Woohoo! Collaboration for the win!
My email is benwilkoff Gmail.com
Woohoo! Collaboration for the win!
My email is benwilkoff Gmail.com
Woohoo! Collaboration for the win!
My email is benwilkoff Gmail.com
For some reason the mobile app obscured my email address, but hopefully that makes sense.
For some reason the mobile app obscured my email address, but hopefully that makes sense.
For some reason the mobile app obscured my email address, but hopefully that makes sense.
OH MY GOODNESS. This has got to be one of the most amazing scripts I have seen. Thank you for sharing it. I am playing right now!
OH MY GOODNESS. This has got to be one of the most amazing scripts I have seen. Thank you for sharing it. I am playing right now!
OH MY GOODNESS. This has got to be one of the most amazing scripts I have seen. Thank you for sharing it. I am playing right now!
Is it working? You don’t realise how happy that makes me feel. I’m new to the game 🙂
Is it working? You don’t realise how happy that makes me feel. I’m new to the game 🙂
Is it working? You don’t realise how happy that makes me feel. I’m new to the game 🙂
It isn’t working perfectly just yet because I have fields/tags that have spaces in them. It looks like it isn’t working with those. Any thoughts?
It isn’t working perfectly just yet because I have fields/tags that have spaces in them. It looks like it isn’t working with those. Any thoughts?
It isn’t working perfectly just yet because I have fields/tags that have spaces in them. It looks like it isn’t working with those. Any thoughts?
I see, that’s a good point. I’m moving house soon so it might be a few weeks until I can look into it but I imagine it wouldn’t be too difficult to solve. If you see any other bugs please let me know.
I see, that’s a good point. I’m moving house soon so it might be a few weeks until I can look into it but I imagine it wouldn’t be too difficult to solve. If you see any other bugs please let me know.
I see, that’s a good point. I’m moving house soon so it might be a few weeks until I can look into it but I imagine it wouldn’t be too difficult to solve. If you see any other bugs please let me know.
Looking at it again, it seems I did consider spaces and I tested with a space in the column heading and in the rows of data, both seem to be handled ok. Can you share your Sheet?
As for the cursor position – it was really easy to update that so you can add “tags” wherever your cursor is.
Looking at it again, it seems I did consider spaces and I tested with a space in the column heading and in the rows of data, both seem to be handled ok. Can you share your Sheet?
As for the cursor position – it was really easy to update that so you can add “tags” wherever your cursor is.
Looking at it again, it seems I did consider spaces and I tested with a space in the column heading and in the rows of data, both seem to be handled ok. Can you share your Sheet?
As for the cursor position – it was really easy to update that so you can add “tags” wherever your cursor is.
I will try again this evening and let you know if I figured out a different cause
I will try again this evening and let you know if I figured out a different cause
I will try again this evening and let you know if I figured out a different cause
Alright, I think I isolated it. It looks like tags with a question mark in them aren’t coming through correctly. I’m going to play around to see if I can figure out how to make them work, but I think that is the issue.
Alright, I think I isolated it. It looks like tags with a question mark in them aren’t coming through correctly. I’m going to play around to see if I can figure out how to make them work, but I think that is the issue.
Alright, I think I isolated it. It looks like tags with a question mark in them aren’t coming through correctly. I’m going to play around to see if I can figure out how to make them work, but I think that is the issue.
It looks like if I just leave off the question mark, the tag comes through. I can’t use the buttons in options, though. It just pulls in []
It looks like if I just leave off the question mark, the tag comes through. I can’t use the buttons in options, though. It just pulls in []
It looks like if I just leave off the question mark, the tag comes through. I can’t use the buttons in options, though. It just pulls in []
That works for question marks at the end of the tag, but not in the middle. It also seems to have a hard time with Parenthesis and other special characters like / or *.
That works for question marks at the end of the tag, but not in the middle. It also seems to have a hard time with Parenthesis and other special characters like / or *.
That works for question marks at the end of the tag, but not in the middle. It also seems to have a hard time with Parenthesis and other special characters like / or *.
I’ve fixed it to accept special characters other than _
I might look at fixing that too but I don’t have time at the moment.
I’ve fixed it to accept special characters other than _
I might look at fixing that too but I don’t have time at the moment.
I’ve fixed it to accept special characters other than _
I might look at fixing that too but I don’t have time at the moment.
Thank you! I will be playing with it today.
Thank you! I will be playing with it today.
Thank you! I will be playing with it today.