Connect to Google Sheets

Let's walk through getting your data from Google Sheets to JobBoardSheet.

Estimated setup time: 3-5 minutes.

Publish your Google Sheet and copy the URL to it

In order to connect your Google Sheet Database to JobBoardSheet first you need to publich your spreadsheet to the web. Afterwards simply copy-paste the URL to your Google Sheet. Follow the video below to see all the steps. You will only need to do this one time.

  1. Open your Google spreadsheet
  2. Click on the green Share button in the top right
  3. Click on the Change button below "Anyone on the Internet with this link can view"
  4. Click on the Copy link button - it copies the URL to your spreadsheet
  5. Click on Done
  6. The sharable Link looks as: https://docs.google.com/spreadsheets/d/13HVlOBtEqTyBBtcnfayAuhp5ZuPXYqq1aY9NCysYKyM/edit#gid=0
  7. Paste the Google Sheet URL to Google Sheet link input field

Find the correct table index

You have an option to create multiple tables in your Google Sheet. Tables are ordered in the bottom-bar.

For JobBoardSheet to be able to find your jobs table, you just need to tell us the index number of your job table.

Same as in the example above, simply just enter the index number (between 1 - 99) to the index number field.