Битрикс24 and Google Sheets automations

Ready-made scenarios where Битрикс24 and Google Sheets work for you: pick one — a copy appears in your account and runs on its own.

93 scenarios

Records from Google Sheets become tasks in Bitrix24
Rows in Google Sheets become tasks in Bitrix24
A spreadsheet row becomes a task
New Google Sheets rows — contacts in Bitrix24
New rows in Google Sheets — tasks in Bitrix24
Daily Bitrix24 forecast logged into Google Sheets
Contacts logged into a spreadsheet
Ad leads — straight into your CRM and your sheet
Data shaped to the table format — prepared automatically before writing
A form request into a tracker issue
CRM deals into a sheet — a pipeline snapshot
Dead feature flags, found for you
Enriching leads with contacts — drop a sheet, get a filled CRM
Leads scored and routed to a rep — straight from the form
Tasks go to the person who knows the subject, not the one who replied first
Candidate shortlisting, emails and screening tasks
Unpaid-invoice control: task and email — on their own
Which channel brings deals — a per-source breakdown in Telegram
Urgent tasks that don't stall
Lead scoring and routing: hot leads straight to sales
Win back abandoned Shopify carts by email and in CRM
Onboarding a hire from a form: chats, a task and access
CRM company and task from a form submission
A personalized sales proposal from a table row, ready and sent
New-lead handling: CRM entry, team alert and reminder
Contractor payouts calculated from closed tasks
Meeting notes — into tasks, participant emails and a summary
An idea from your notes into a ready plan to approve
Tickets prioritized by importance, tasks created for you
Contacts tagged by role and seniority — automatically
Stuck tickets, followed up automatically
Resumes from a folder into a candidate card and a hiring task
Data-load failure monitoring with tasks and alerts
Feedback sorted by sentiment — and every complaint becomes a ticket
Sales cycle analysis and recommendations — automatic
Compare each proposal against your winners and find the gaps
Team-capacity tracking with over-allocation alerts
Topic legislation tracker with tasks
High-value lead alerts — to chat, sheet and calendar
Full company records in your CRM, from a domain list
Hiring spikes at your accounts — straight to team chat
Polite candidate rejections sent by email, with the task closed
A lead replies — the CRM card updates and a task lands on a rep
Today's top 10 hot leads — with tasks
New-issue triage: task, notification, reply to the author, and a logged row
Client renewal reminders — ahead of time
Capture and route leads from every channel
Meeting attendance: a log, the late list and a summary in your chat
A daily numbers summary — to chat and email
Jira epic health tracking with risk alerts
Collect client reviews and summarize them to chat automatically
Score event RSVPs and route them to sales
A sales leaderboard with a personal word to the team — automatically
Client onboarding from a questionnaire: project, tasks, channel, email, CRM
CRM deals synced to a sheet, with a daily email summary
Alerts for customers losing interest: to the rep, into a task, and by email
Meeting prep that arrives on its own — contact, deals, company and talking points
Automated market reports for your clients
Campaign and deal analytics — in one table
Incident response — ticket, alert, and report in seconds
Automatic follow-ups for prospects who went quiet
Re-engaging quiet clients — weekly, without manual tracking
Invoices from email into accounting, with approval
Release notes from closed tasks — published everywhere at once
Content ideas from your audience's real pain points
Reorder recommendations from your stock table — automatically
A morning traffic summary for your site — in plain words
Change request routing: tickets, audit trail and notifications
Route change requests by the rules — no manual triage
Daily task summaries and a weekly report by email
Tell customers their bug is fixed — the moment the issue closes
Customer feedback sorted into themes, tasks and a weekly report
Website leads straight into CRM deals, with a team alert
Lead gathering and drafted emails for approval, sending the approved
Customer churn prediction from deals and tickets
Automatic scenario check with an error report
Incoming lead sorting and routing — automatically
A full new-client welcome after the form
Auto-booking demos for high-intent leads
Lead verification, enrichment and sorting — automatically
Feedback from every channel into a prioritized queue
Personal emails to new contacts — built from their own socials
Warm B2B leads with a personal video for each
Open-house lead follow-up — a week-long touchpoint sequence on autopilot
Lead reply intent sorting with ready tasks in ClickUp
Tester feedback triage: tickets, knowledge base and a reply to the author
Sort email leads and file them into the CRM — by importance
Meeting recording → tasks, a client email and an updated CRM record
Feedback triage and customer replies — automatically
Adding and enriching CRM leads without duplicates
Every sale — logged, a ping to you and a thank-you to the buyer
AI marketing outreach with reply handling — on autopilot
BANT call qualification and CRM handling — on autopilot