Are you tired of copying and pasting information from your open tabs into a spreadsheet when you’re sourcing candidates or prospecting leads. Well, Magical has a trick for you to save you time filling out your sheets.
1. Open up the tabs where you’d like to transfer data from.
Magical works by communicating with your open tabs. Open up the tabs where you’d like to pull data from. In the example below, we’ve opened up several LinkedIn profiles we’re interested in.
2. Make sure Magical knows what variables you want transfer
To see what variables exist: click on the Magical icon from your web browser to open the panel, and click Edit Variables. You will see different elements highlighted on the page. These are the variables that already exist that you can use in your work.
To create a variable: navigate to a site, click on the Magical browser icon and click Edit variables. Click elements on the page that you’d like to label, add a label and click Save.
3. Show Magical how to transfer your variables to your sheet
In Google Sheets, type // to fill in a sheet’s row of cells with your open tab’s variable data. Magical will remember this mapping between your sheet’s cells and the variables from LinkedIn.
4. Where the magic happens
On the next row, type // again and click Fill everything. Magical will populate the rows below with information from the remaining tabs you have open.
5. Need to start over?
If you fill out the sheet incorrectly and want to start over, type // and click “remove magic mapping”. This will allow you to start over and re-map the variables to the sheet’s cells.