app script | Max行銷誌

30 10 月, 202219 11 月, 2022All posts、Looker Studio 教學、Python 數據分析By Max

Build up your Blog Monitor with Google sheet

This tutorial is a step-by-step explanation of how to build up a blog monitor. We will use the Google Sheet to get the website status and Google Looker Studio to display the blog status. In the end, you will build up the dashboard as below. 1. Copy the google sheet First, copy this google sheet here. Next, you need to modify the column A and column […]

閱讀全文

13 10 月, 202217 10 月, 2022All postsBy Max

[App Script] How to copy sheet to another sheet

How to copy sheet to another google sheet? First, we import our source sheet and target sheet by ss_spreadsheet, ts_spreadsheet. Then we can use copyTo function to copy the tab to another spredsheet tab. How to copy one raw to target raw? In this case, we also need import our source sheet and target sheet by ss_spreadsheet, ts_spreadsheet. Second, […]

閱讀全文