How to add a spreadsheet to a template?

Carry

Hi everyone, I am in the process of setting up our classroom attendance spreadsheets for this year. I installed the Attendance Management, but the workflow only comes with three templates. We do have a fourth class that I need to add. How can I connect a new spreadsheet to the workflow? I could use some help, I am afraid I might break the existing connections.

Vitor from Sheetgo

Hello Carry glad to know that you intend to use our Attendance Management template. To add a new spreadsheet to it you can follow these basic steps:

Go to Google Drive/OneDrive
Copy one of the existing spreadsheets from the template, and rename it;
Open Sheetgo and go to the Attendance Management workflow;
Click on the 3-line menu, at the top right corner of the page, to open the connections menu;

Then select which connection you need to edit and click on the 3-dots menu (⋮);

Now select Edit and you will be able to start editing the connection;

On the Source box, click on Edit;

Now you will be able to see the spreadsheets that are already connected. Click on +Add another source file;

Click on + Select file and locate the new file (the copy you have just created) inside your Drive.

Important: in the FILE TAB select the right tab for the connection you are editing, if you are editing the Overview per student connection, select the Overview per student tab;

Click Done and then Save changes.
Congrats you added a new spreadsheet to the connection!
Important: You will need to repeat this process for each of the connections on the workflow. This template has 3 connections, so you will need to repeat the same process to add the new spreadsheet inside each connection.

Follow these steps and let me know if you have any doubts about it 🙂

Carry

Vitor from Sheetgo this is great Vitor, thank you for the assistance

David

Vitor from Sheetgo Hi Vitor, could you help me how could I change the sheet’s name?

Vitor from Sheetgo

Hello David if you are using Google Drive you can follow these steps

Go to Google Drive > Sheetgo templates > Attendance Management
Select which spreadsheet you want to change the name, right-click on it and select Rename