Apps: connect Zoom, Google Sheets and your forms

What's on the Apps page

Lead link

Click Get my link on the Lead link card. Keep the link private, like a phone number for enquiries. Any form that can send its answers to a web address can use it, and each enquiry arrives in Admissions marked Lead link. You get a bell and an email, and the enquiry goes on to WhatsApp, Send to apps and Google Sheets like an enquiry from your Sikhami page.

Use it with your forms

• Your website: the card shows a ready HTML form. Paste it into your page. After sending, people see a short thank-you page, or your own page if you add its address on the card.
• Google Forms: the card shows a few lines of Apps Script. In your form, open the script editor, paste them, match the question titles, and add an "On form submit" trigger.
• Facebook and Instagram lead forms: in Pabbly Connect, Zapier or Make, use the trigger "New lead" from Facebook Lead Ads, then a Webhook (HTTP POST) action to your link with the fields name, phone, email and form.

Send a test lead checks the link without saving anything. A form tool can do the same by sending test = true.

Zoom

Sikhami makes meetings in your own Zoom account, so classes run on your Zoom plan and recordings stay with you. You connect Zoom once, with a small app you make in your Zoom account. Zoom does not need to review it, because only your account uses it.

1. 1
   Go to marketplace.zoom.us and sign in as your Zoom account's owner or admin.
2. 2
   Choose Develop, then Build App, then Server-to-Server OAuth app. Give it a name, such as Sikhami.
3. 3
   Under Scopes, add meeting:write:meeting:admin, meeting:read:meeting:admin, meeting:update:meeting:admin, meeting:delete:meeting:admin and user:read:user:admin.
4. 4
   Activate the app.
5. 5
   On Sikhami's Apps page, click Connect on the Zoom card. Copy the Account ID, Client ID and Client secret from the app's App credentials page, and type the Zoom email of the person who hosts your classes.
6. 6
   Click Connect. Sikhami checks the details with Zoom at once.

Making links

• A batch: open the batch, choose Online or Hybrid, and click Make a Zoom link under Live class link. Sikhami makes one recurring Zoom meeting for the batch, a link that stays the same for every class. Save the batch to keep it.
• A workshop: click Make a Zoom link under the joining link. Sikhami makes a Zoom meeting at the workshop's time and length. When you change the time or title and save, the Zoom meeting moves too. When you cancel or delete the workshop, Sikhami deletes the meeting.

Google Sheets

Click Connect on the Google Sheets card, then Connect Google, and allow access in Google's window. Sikhami makes one spreadsheet named after your institute or business in your Google Drive and opens a tab for each kind of record. Google lets Sikhami see and change only that spreadsheet, nothing else in your Drive.

• Switch each tab on or off on the card. Rows start from the moment you connect; earlier records are not copied.
• Rows usually arrive within a minute. On a very busy minute they wait their turn.
• Sort, filter and add your own columns as you like, but do not rename or delete the tabs Sikhami writes to.
• Make a new sheet starts a fresh spreadsheet; the old one stays in your Drive. Disconnect stops new rows and gives up Sikhami's access. Your spreadsheet stays yours.

Limits and pauses

Each institute and seller has its own limits, so no one's busy day slows anyone else down.

When Zoom or Google refuses Sikhami (the Zoom app was deleted, Google access was removed, the spreadsheet was deleted), or after 10 failures in a row, the app shows Paused with the reason. Connect again, or make a new sheet, to start it again.

When the LMS free month or plan, or a course seller's trial or plan, ends, apps pause: the Lead link stops taking enquiries, no Zoom links are made and no rows are added. Nothing is deleted, and you can still disconnect apps. Everything works again when a plan starts.

Questions