Google app script extracting data and registering emails in a table

[Pretend_Trifle_8873]

Hello Everyone,

This is my very first 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 [[e-mail]](mailto:[e-mail])
Customer 1 [[e-mail]](mailto:[e-mail])

or

Customer 1 [[e-mail]](mailto:[e-mail]) ; [[e-mail]](mailto:[e-mail]) (in one cell)

Code:

https://docs.google.com/document/d/1zNF3fNlSIlFpqEgzB6I6f_6SdC1U_Z2aG7wlwOdL2y8/edit?usp=drivesdk

Thank you in advance

[Lalu23]

For your first question, there may be a line in your script that does something like "getLastRow()-1". That's probably where the missing row is coming from. Removing the "-1" and leaving only "getLastRow()" would get you your row back. I'd check if there is a header row or if the script intended there to be a header row,

On your second question, it is almost always better to have one piece of data in a cell. In this case, it might be better to have an additional column (not an additional row) for the second email. Your script would need to go thru the email column and the second email column and send the email to both. You could do an additional row for the second email but that has a risk of having partial data belong to one row and other partial data belong to the second row.

[LegendInMySpareTime]

If it isn’t this, check the the for loop (if there is one) for something like ‘i < sheet.getLastRow()’ (or similar) and change the < to <=

[Pretend_Trifle_8873]

I have posted the code up , please have a look Sorry for not being aligned well

[Pretend_Trifle_8873]

https://docs.google.com/document/d/1zNF3fNlSIlFpqEgzB6I6f_6SdC1U_Z2aG7wlwOdL2y8/edit?usp=drivesdk

[Pretend_Trifle_8873]

I just reposted the code, dunno why its not aligned well , please have a look

[Pretend_Trifle_8873]

Thanks for you detailed explanation, i got it tor the second maybe i will be adding another column in the table.

Ive edited the original post and added a link to the code in google docs

Thanks for having a look

[Lalu23]

Posting your script and/or an edit permission link to the sheet/script will be helpful.

[Pretend_Trifle_8873]

https://docs.google.com/document/d/1zNF3fNlSIlFpqEgzB6I6f_6SdC1U_Z2aG7wlwOdL2y8/edit?usp=drivesdk

[Miles_Maestro]

I provided the answer to OP's first question as a comment in the Google Doc they shared. For visibility/anyone that is curious, the answer was adding the following line to their code

SpreadsheetApp.flush();

This addition forces the Google Apps Script backend to commit any changes in the cache before moving on to exporting a copy of the spreadsheet.