3 of 16

The Scenario

Why would you use Sheet Spider?

When you have a spreadsheet with data that needs to be distributed to multiple recipients with information specific to each recipient.

The Scenario:

Master Roster for School Counselors in one “original” spreadsheet

Each counselor needs a roster “new spreadsheet” of only their students
Information on GPA, Regents Exams and Registration needs to be shared back and forth between administration and the counselors

The Solution:

Sheet Spider

Create a new spreadsheet for each counselor from one original
Share information between all
Retrieve all updates made by counselors in the registration column

4 of 16

How to get the Add-On

1. Sheet Spider can be accessed from

the Add-On Store in your spreadsheet

2. Search for Sheet Spider and install the Add-on. Agree to the terms of use and you are ready to launch.

5 of 16

Getting Started: Launch Sheet Spider

First you will need an original spreadsheet that is already created and contains all the data you need to create the new spreadsheets.
From the add-ons menu on your spreadsheet, Launch Sheet Spider
Click Get Started

6 of 16

Select Your Spreadsheet and Source Column

Select the tab of your spreadsheet that you want to run Sheet Spider on

In this instance, a new spreadsheet will be created for each counselor listed in column A with only their students.

7 of 16

Saving & Naming your new spreadsheets

Select a folder on your drive

Your new sheets will be named with the source column headers data + optional text (you create)

Ex: Roster 18

8 of 16

Back to the Scenario

For this example ‘Column A’ or ‘Counselor Name’ was chosen.

6 new spreadsheets will be created for each counselor, containing their associated data in that row

9 of 16

To create new spreadsheets for each counselor

Sheet Spider is working…...

10 of 16

You now have a Summary ‘Sheet Spider’ Tab on your original spreadsheet

Links to new spreadsheets

Summary Tab

Right now the Summary “Sheet Spider” tab gives you the following info:

Names of the new spreadsheets

Links to your new spreadsheets

How many rows were transferred

The date the data was transferred

Never Delete the “Sheet Spider”

11 of 16

Relaunch Sheet Spider to see more Options and Share Your Spreadsheets

When you launch Sheet Spider again, you have more options

Next step:

Share the new spreadsheets

12 of 16

Sharing new Spreadsheets

Select your editors column

Sheet Spider shares the new spreadsheets based upon a column of email addresses found in your spreadsheet

These email addresses must be Google based

2. (Optional) You may also select another column of email addresses to be viewers

select to directly send to recipient

13 of 16

Retrieve Data

The counselors have now received the new spreadsheets and can start adding data.

Next Step:

Launch Sheet Spider to retrieve this data.

14 of 16

Returned Data Tab Created

You now have a new tab “Returned Data”, where all the retrieved information will live.

You can not push new data from this tab.

Data will only be pushed from the “Sheet 1” tab.

15 of 16

More information on the ‘Sheet Spider’ Summary Sheet

Names of and live links to new spreadsheets

Date & time confirmation of information transfers

List of editors and viewers for each spreadsheet

16 of 16

Push, Retrieve and Repeat !

If you have new information on ‘Sheet 1” to push out to the counselor spreadsheets, Launch Sheet Spider and select “Push New Data”

Push, Retrieve & Repeat!

You are finished setting up Sheet Spider !!