GOOGLE FORM RESPONSES TO SLACK (FREE): Google Sheets + Slack (Make.com template) v1.0
by Flowpaja

WHAT IT DOES
  Make checks the response sheet of your Google Form on your schedule. For each NEW response it posts
  one Slack message to the channel you choose: Name, Email, Company, Message, the timestamp and the
  sheet row. Empty answers show as a dash. Rows without a Timestamp are skipped.

FILES
  SETUP_GUIDE.pdf                               Start here. 2 pages: setup, test, limits, fixes.
  Flowpaja_Form_to_Slack_FREE_blueprint.json    The Make scenario (2 modules). No connections or IDs inside.
  Form_to_Slack_EXAMPLE_sheet.xlsx              The 5 columns with 3 fictional responses (tabs: Form Responses 1, How to use).
  Form_Responses_1_tab.csv                      The same rows as CSV.

SETUP IN SHORT (details in SETUP_GUIDE.pdf)
  1. Google Forms: questions named Name, Email, Company, Message. Responses > Link to Sheets.
  2. Make: Create a new scenario > ... (More) > Import Blueprint > choose the .json file.
  3. Module 1 (Google Sheets): add your Google connection, choose the linked spreadsheet and the tab "Form Responses 1".
  4. Module 2 (Slack): add your Slack connection. In "Channel ID or name" type your channel, e.g. #form-responses.
  5. Right-click module 1 > Choose where to start > From now on. (Otherwise old responses are posted too.)
  6. Submit a test response in your Form, click Run once: one Slack message.
  7. Schedule: e.g. every 15 minutes or every hour, then switch the scenario ON.

IMPORTANT
  - Credits: every scheduled check uses 1 credit, even when nothing is new, plus 1 per new response.
    Every 15 minutes = up to 96 checks a day (about 2,900 a month). Make's Free plan has 1,000 credits a month,
    so on the Free plan choose every hour or less often (check make.com/pricing).
  - Duplicate submissions are posted twice. Edited rows are not posted again.
  - Don't leave a completely blank row in the response sheet: Watch New Rows stops reading at a blank row.
  - If you add a Form question in the middle, check that the Slack text still maps the right columns.

WANT EACH RESPONSE SAVED IN HUBSPOT TOO?
  Lead Router ($19, Make.com template): Google Form -> HubSpot contact (created or updated by email, no duplicates)
  -> Slack, with $10k+ budgets sent to #sales-hot, repeat submissions marked "(updated)" and error alerts.
  https://flowpaja.gumroad.com/l/lead-router-make-template?utm_source=flowpaja.com&utm_medium=make_template&utm_campaign=lite_a
  All 3 Flowpaja templates: $39 bundle at https://flowpaja.com/templates/

NEW TO MAKE?
  Free account: https://www.make.com/en/register?pc=flowpaja
  (affiliate link: Flowpaja may earn a commission if you later buy a paid Make plan, at no extra cost to you.)

Questions: flowpaja.fi@gmail.com

License: free to use in your own Make account(s) and for your own clients. Please link to flowpaja.com
instead of re-uploading the files elsewhere.
Make, Google, Google Forms, Google Sheets and Slack are trademarks of their owners. Flowpaja is independent and not affiliated with them.
