When sending email from Google Sheets, how do I print a spreadsheet to PDF with the right side fixed and the data on the left side constantly added?

Question

Google Sheets

Tell me how to make it so that in Google sheets, after setting the checkbox (checkbox) opposite the cell with the last name of a particular employee, a part of the table in pdf format is automatically formed and sent to the selected employees by mail?

The query is complicated by the fact that part of the table columns on the left is frozen (that is, it is always visible, they have a list of tasks), and the part of the table on the right is constantly updated (dates are added every day). And I need to send employees not a long sheet, but only fixed columns on the left and a few columns on the right with actual dates.

Answer 1

It is necessary to divide the Table into separate components, for example, using the PRF principle . The print sheet must be separate. Further already through scripts to print.