How to Integrate Google Sheets with KWIC
Google Sheets plays a vital role when integrating with the KWIC application. It helps collect, store, and organize customer data seamlessly — without disrupting the user experience.
This connection improves contact management, automation, and customer support capabilities.
Step 1: Login with KWIC
- Open the KWIC application
- Log in using your registered credentials
Step 2: Integrate Your Google Account
- Go to the Integration section
- Click Continue
- Choose the Google account you want to connect
- Click Next, then Continue
Your Google account will now be successfully linked with KWIC.
Step 3: Create a Flow Connected to Google Sheets
- Navigate to the Automation section
- Click Create New Flow
- Add a suitable title
- Use Drag & Drop to build your flow and collect customer inputs
Under the Integration section → choose Google Sheet → select your account and spreadsheet.
Assign variables to specific Google Sheet columns so collected responses are stored correctly.
- Question: “Which color do you prefer?”
→ Mapped to Column 1 (Variable: color)
- Question: “What is your expected price range?”
→ Mapped to Column 2 (Variable: price)
After mapping, select your Google Account → choose your Spreadsheet → click Save.
To activate the flow, add it under Custom Reply Material and assign a keyword trigger like “hi” or “hello”.
Step 4: Execute Google Sheet Integration with KWIC
After connecting your Google Sheet:
- Send the trigger keyword (e.g., hi or hai) from another mobile number to your KWIC-linked WhatsApp
- Your flow will begin automatically
- KWIC will ask all configured questions (e.g., color, price)
- All customer responses will be saved directly into your Google Sheet
This allows real-time data collection, smarter customer management, and faster support automation.
