Skip to content

Google Sheets + SOLAPI

Google Sheets + SOLAPI

Google Sheets + SOLAPI integrations

Send one button kakao messages in SOLAPI for new or updated Google Sheets rows

Keep your team informed with real-time updates by sending a Kakao Message when a Google Sheets row changes or gets added. This workflow streamlines your communication process, ensuring that essential information is shared promptly without manual effort. Enhance collaboration and efficiency within your team with this easy-to-set-up automation.

When this happens...
New or Updated Spreadsheet RowTriggers when a new row is added or modified in a spreadsheet.
TriggerInstant
automatically do this!
[Messaging] Send Kakao AlimTalkSend a Kakao AlimTalk BusinessMessage. "AilmTalk Template" registration is required before sending. | 카카오 알림톡 메시지를 발송합니다. 알림톡 템플릿 사전등록이 필요합니다.
ActionWrite

Start free with email

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google Sheets and SOLAPI

Discover other triggers and actions you can use with Google Sheets and SOLAPI

- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Instant
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Column_name
  Required
- Index
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write

- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Frozen Rows Count
- Frozen Columns Count
- Sheet Position
- Hide Sheet
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Source Range
  Required
- Destination Range
  Required
- Paste Type
Action
Write

- Drive
- Title
  Required
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Info
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row(s)
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Validation Type
  Required
- Input Message
- Strict Validation
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row
  Required
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Columns
  Required
- Row count
  Required
- Output format
- First row
Action
Search
- Spreadsheet ID
  Required
- Include Grid Data
Action
Search
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
[Messaging] New Group Report
After requesting to send the message, all processing of the message group is complete. | 메시지 그룹 내 모든 메시지들의 처리가 완료되었을 때 실행됩니다.
Trigger
Instant
Try It
- Commerce Hook | 커머스 자동화
  Required
Trigger
Instant
Try It
- CRM Entity | CRM 개체
  Required
Trigger
Polling
Try It
- CRM Entity | CRM 개체
  Required
- CRM Record | CRM 레코드
  Required
- Event Type (Optional) | 이벤트 유형 (선택)
Trigger
Polling
Try It
- CRM Entity | CRM 개체
  Required
- CRM Record | CRM 레코드
  Required
Trigger
Polling
Try It
- Activity Type | 활동 유형
  Required
- Subject | 제목
  Required
- Description | 설명
- Scheduled Date | 일정 날짜
  Required
- Due Date | 마감일
- Duration (minutes) | 소요 시간 (분)
- Assigned Member | 담당자
- CRM Entity | CRM 개체 (선택)
Action
Write
- Default Entity | 기본 개체
- Default Record | 기본 레코드
- Events (JSON Array) | 이벤트 목록 (JSON 배열)
  Required
Action
Write
- CRM Entity | CRM 개체
  Required
- CRM Record | CRM 레코드
  Required
- Activity Type | 활동 유형
  Required
- Subject | 제목
  Required
- Description | 설명
- Scheduled Date | 일정 날짜
- Due Date | 마감일
- Duration (minutes) | 소요 시간 (분)
- Assigned Member | 담당자
Action
Write
- Kakao Channel ID (PFID) | 카카오 채널 ID (PFID)
  Required
- Kakao Template ID | 알림톡 템플릿 ID
  Required
- Recipient number | 수신번호
  Required
- Country code | 수신자 국가코드
- Sender number | 문자 대체발송 발신번호
Action
Write
- Recipient number | 수신번호
  Required
- Kakao Channel ID (PFID) | 카카오 채널 ID (PFID)
  Required
- Contents | 브랜드 메시지 내용
  Required
- Sender number | 문자 대체발송 발신번호
- Country Code | 수신자 국가코드
- AD | 광고 여부
- Image ID | 이미지 ID
- Buttons | 브랜드 메시지 버튼
Action
Write
- Recipient number | 수신번호
  Required
- Sender number | 발신번호
  Required
- Contents | 문자 내용
  Required
- Subject | 문자 제목 (입력 시 LMS로 발송)
- MMS Image ID | MMS 이미지 ID
- Splitting when over max contents length | 최대 길이 초과 시 나누어 보내기
- Country Code | 수신자 국가코드
Action
Write
- CRM Entity | CRM 개체
  Required
- CRM Record | CRM 레코드
  Required
- Record Name | 레코드 이름
- Tags | 태그
- Owner | 담당자
Action
Write

- Dont_change_sheet_structure
- No_team_drive
- Spreadsheet
  Required
- Worksheet
  Required
Trigger
Instant
Try It
- Dont_change_sheet_structure
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Trigger column
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
Trigger
Polling
Try It
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Condition Type
  Required
- Background Color
- Text Color
- Bold Text
- Italic Text
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to Copy
  Required
- Worksheet to Copy
  Required
- Copy Worksheet Destination
Action
Write
- Drive
- Spreadsheet
  Required
- Title
  Required
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Confirm Deletion
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Format Type
  Required
Action
Write
- Spreadsheet
  Required
- Worksheet
  Required
- New Sheet Name
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Cell Range
  Required
- Sort by Column
  Required
- Sort Order
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
Action
Write
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- A1 Range
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Row ID
  Required
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- Spreadsheet
  Required
- Worksheet
  Required
- Lookup column
  Required
- Lookup value
  Required
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
- Result | 메시지 결과
  Required
- MessageType | 특정 메시지 종류와 일치
- From | 특정 발신번호 (숫자만)
- To | 특정 수신번호 (숫자만)
- Kakao Channel ID | 특정 카카오 채널 ID
- Kakao Template ID | 특정 알림톡 템플릿 ID
Trigger
Instant
Try It
- CRM Entity | CRM 개체
  Required
- Event Type (Optional) | 이벤트 유형 (선택)
Trigger
Polling
Try It
- CRM Entity | CRM 개체
  Required
- CRM Record | CRM 레코드
  Required
- Event Type (Optional) | 이벤트 유형 (선택)
Trigger
Polling
Try It
- CRM Entity | CRM 개체
  Required
Trigger
Polling
Try It
- Address Book Folder ID | 주소록 폴더 ID
  Required
- Phone Number | 추가할 전화번호
  Required
- Name | 이름
Action
Write
- CRM Entity | CRM 개체
  Required
- CRM Record | CRM 레코드
  Required
- Event Type | 이벤트 유형
  Required
- Category | 카테고리
- Label | 라벨
- Value | 값
- Occurred At | 발생 시각
- Custom Properties (JSON) | 사용자 정의 속성 (JSON)
Action
Write
- CRM Entity | CRM 개체
  Required
- Record Name | 레코드 이름
  Required
- Tags | 태그
- Owner | 담당자
Action
Write
- CRM Entity | CRM 개체
  Required
- CRM Record | CRM 레코드
- Event Type (Optional) | 이벤트 유형 (선택)
Action
Write
- Kakao Channel ID (PFID) | 카카오 채널 ID (PFID)
  Required
- Brand Message Template ID | 브랜드 메시지 템플릿 ID
  Required
- Recipient number | 수신번호
  Required
- Country code | 수신자 국가코드
- Targeting | 타겟팅
  Required
Action
Write
- RCS Brand | RCS 브랜드
  Required
- RCS Template | RCS 템플릿
  Required
- Recipient number | 수신번호
  Required
- Sender number | 발신번호
  Required
- Country code | 수신자 국가코드
Action
Write
- Request URL
  Required
- HTTP Request Method
  Required
- Body Parameters (JSON Format String)
Action
Write
- CRM Entity | CRM 개체
  Required
- CRM Record | CRM 레코드
  Required
- Property | 속성
  Required
Action
Write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn moreLearn moreHelpHelp

Related categories

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

About SOLAPI

SOLAPI app for sending text messages with KakaoTalk.

Learn moreLearn moreHelpHelp

Related categories

Related Zap Templates

Related Zap Templates