서비스
home

Transform Business with autooffice

who we are

autooffice is a dev studio with Google Workspace Automation & Looker Studio Dashboard & AppSheet Experts.

David
Joowon
Jinsoo
운영 효율성을 높이고, 실시간 현황을 파악하면 사업을 성장시킬 전략이 보입니다. 인력이 부족해서 효율화를 미루면 사업이 정체되거나 큰 위험에 처할 수 있죠. 업무 자동화대시보드로 생산성을 높이는 일은 성과를 바로 볼 수 있어 흥미진진합니다. by David
Google Workspace Integration
Business Intelligence Dashboard
28년차 센서기업 (주)아이에스테크놀로지 차장 서** 님 / 구글 워크스페이스 기반 대용량 스크립트
모빌리티 통합 서비스 차봇모빌리티(주) 매니저 신** 님 / 구글 워크스페이스 기반 정산 구글 시트 & 스크립트

what we do

We Automate, Visualize, and Mobilize your Business with Google Applications.

Google Apps Script
Visualize
Mobilize

1. Google Workspace Automation

No More Copy & Paste. No More Meaningless Repeat.

Leave it to Pivot, Query and Powerful Apps Script.

Startups, Small & Medium Enterprises (SME) utilize Google Workspace, especially Google Sheet, to work together and maximize productivity.
However, if your company doesn’t use pivot, query, and especially Apps Script, you don't get the best out of the Google ecosystem.
Without these powerful features, you or your employees have to repeat labourous work. Many times this results in fatigue, mistakes, and loss of money.
Google Sheet
Google Apps Script

Speed up and Automate your work with codes! You will get the desired results just with a few clicks.

Then you will have more time to concentrate on more important things.

What You Can Do with autooffice

Generate PDF Invoices of 100 Buyers and Send Emails
Send Sales Reports Daily / Weekly / Monthly via Email or MMS or API
Search and View Inventory or Sales Data with Keyword Inputs
Generate Google Slides or Docs from Google Sheet Data
Automate Complex Financial Calculations
캐나다 토론토의 Kitchenware 소매점 Placewares 대표 박** 님 / 구글 앱스 스크립트로 재고 검색 및 업데이트 자동화
Samples ▼
중장비타이어 전문 바코리아타이어(주) 대표 이** 님 / 구글 시트 업무 자동화
OBD 스타트업 (주)비트링크 팀장 이** 님 / 구글 시트 업무 자동화
전국 대표 방역 업체 (주)더구름 고** 대표님 / 구글 시트 업무 자동화

2. Looker Studio Dashboard

Overview Business Performance in Realtime

By connecting your Data to Google Looker Studio

Do you wait until your employees to make report for you? Do you spend much time regularly to understand your business performance?

The Faster you get the Reports, The More you get Precious Time.

Time to Consider, Make the Best Decision, and Be Proactive.

Business Performance Report
Strategic Decision
You can use Google Sheet, AppSheet, MySql, PostgreSQL, Google BigQuery and etc. as database for Looker Studio. And it is easy to change the perspective of analysis once it’s set up.

What You Can Do with autooffice

Mobile Version of Dashboard
Realtime Sales, Delivery, Inventory Dashboard
Analyze and Compare Revenue, Profit, Popular Items by Branch, Region, Dates and etc.
Process Millions of Rows with BigQuery and Visualize without Freeze of Application. (When Excel or Google Sheet Freezes with Pivot or Graph, Looker Studio is a Solution)
Merge Downloaded Excel Files of Shopping Platform and Update the Dashboard
Sample
머신 AI 기업 (주)마키나락스 안** 님 / Power BI 대시보드 + AWS
전주 대표 치과 보가치과 대표원장 권** 님 / Power BI 대시보드 + Sharepoint

3. AppSheet Mobile App

Mobilize your Work Process

Less Paper, Less Mess. Manage and Proceed at your Fingertips.

Manufacturing, Inventory, or Sales Management are usually done with taking paper notes and entering data using desktop. Don’t you think you are working redundantly? It is absolutely convenient when you can use mobile apps on site.

AppSheet turns Google Sheet into Mobile Apps!

More than Mobility

Reduces Entering Error with Data Validation and Restrictions
Zero Risk of Deleting Google Sheet Functions by Mistake
No More Zoom In/Out of Mobile Screen
View, Edit, Column Permission by Accounts
Sync with Databases such as Oracle
Sending Email, Updating Data, and Various Actions with Automation Bots

What You Can Do with autooffice

Inventory Management of Raw Materials and Products
Update Manufacturing Process on Site and Overview the Progress
Production Management according to Orders
Accouting & Financing (Double Entry Bookkeeping)
Device Maintenance of Local Sites with Photo Uploads

our projects

Short-term Projects (less than a Month) & Long-term Projects (3 ~ 12 Months)
We Only accepts up to 3 Main Projects at the same time for the Best Result
We take Responsibility and provide Paid Maintenance
👫🏻 Our Customers varies: Startups, SMEs, Hospital, Shopping Mall, Distributors (usually $1M ~ $100M revenue)

how we do

Remote Work from Korea
Conference Call(Zoom and Google Meet) & Email Communication in English and Japanese
Work Process

knowhow sharing

Published books

where to contact

Contacts

Google Form (24hr)
Email (24hr)
Phone (Weekday 10:00 ~ 18:00)

Channels

Naver Blog
YouTube

our Affiliates

CharacterBox: 2D Illustration, Cartoon Design
AppDesign: Mobile App Design
HomepageDesign: WordPress, Shopping Mall, Responsive Web Design
2019-2023 autooffice | All rights reserved.