Google app script extracting data and registering emails in a table

55 views
Skip to first unread message

Google Apps Script Community

unread,
Oct 17, 2021, 5:45:48 PM10/17/21
to Google Apps Script Community

This is my very first kinda interaction here. I have written a script in google spreadsheet to extract data from a table and send it automatically by email.

Its all working great for now , but i am having these 2 problems that I hope that someone might help me solve it:

1st problem:

The extracted data isn't including the last row of the table, if the table has 50 rows, its only extracting 49 rows.

2nd Question is: I have a table that has the customer name and customer email address.
Lets say the same customer has 2 emails, should I create 2 rows for the same customer or i can add both emails in 1 cell ?

Example:

Customer 1 imp...@customer1.com
Customer 1 Mark...@customer1.com

or

Customer 1 imp...@customer1.com,mark...@customer1.com (in one cell)


Thank you in advance

Emerson Maia

unread,
Oct 17, 2021, 5:50:13 PM10/17/21
to google-apps-sc...@googlegroups.com
Good night, as you are looking for this data, if it is in an array with map and only you select the value of the map, share your code.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/7e78e305-815c-44c9-801a-ae3114a71b86n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages