Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Instance yang dihosting pelanggan mungkin tidak dapat mengaktifkan tindakan dari Looker Action Hub, terutama tindakan yang mendukung hasil streaming atau yang menggunakan OAuth, jika instance Looker yang dihosting pelanggan tidak memenuhi persyaratan Looker Action Hub.
Apakah pekerjaan Anda mengharuskan Anda menghabiskan banyak waktu di Google Spreadsheet? Anda dapat menggunakan tindakan berbasis OAuth yang aman dari Looker untuk mengirim CSV langsung dari Looker ke Google Spreadsheet secara satu kali atau berulang.
Tindakan Google Spreadsheet terintegrasi dengan Looker melalui Looker Action Hub. Setelah admin Looker mengaktifkan tindakan Google Spreadsheet di Action Hub, pengguna dapat memilih Google Spreadsheet sebagai kemungkinan tujuan saat mengirim atau menjadwalkan Tampilan atau Jelajah.
Halaman ini memandu admin untuk mengaktifkan tindakan Google Spreadsheet di Looker. Panduan ini juga menjelaskan cara setiap pengguna yang memiliki izin yang sesuai dapat mengirim atau menjadwalkan pengiriman dalam format CSV ke Spreadsheet Google.
Mengaktifkan tindakan Google Spreadsheet di Looker
Admin Looker dapat mengaktifkan tindakan Google Spreadsheet di Looker dengan langkah-langkah berikut:
Buka panel Admin dan, di bagian Platform, buka halaman Actions.
Pada daftar tindakan Action Hub, scroll ke Google Spreadsheet, lalu klik tombol Enable.
Di halaman tindakan Google Spreadsheet, klik
tombol Enabled ke posisi aktif, lalu klik
Save.
Saat Anda kembali ke daftar tindakan Action Hub, tindakan Google Spreadsheet akan diaktifkan.
Anda dan pengguna — jika mereka memiliki izin send_to_integration — kini dapat mengirim atau menjadwalkan Tampilan atau Jelajah dalam format CSV ke Spreadsheet Google.
Mengirimkan data dalam format CSV ke Spreadsheet Google
Semua pengguna Looker yang memiliki izin send_to_integration dapat mengirim atau menjadwalkan Penampilan atau Jelajah dalam format CSV ke Google Spreadsheet.
Google Spreadsheet dibatasi hingga 10 juta sel untuk seluruh Spreadsheet. Jika tabel data Anda memiliki kolom, baris, atau tab yang melebihi batas ini, semua pengiriman ke integrasi Spreadsheet Google akan gagal.
Untuk menyiapkan data Anda sebelum mengirim atau menjadwalkannya, ikuti langkah-langkah berikut:
Penskalaan horizontal: Jika tabel data berisi lebih dari 26 kolom dan Anda berencana untuk mengimpor data ke Google Spreadsheet yang ada, Anda harus meluaskan Google Spreadsheet secara manual sebelum dapat mengimpor data ke dalamnya.
Penskalaan vertikal: Jika tabel data Anda berisi lebih dari 1.000 baris, Looker akan menambahkan baris tersebut ke Google Spreadsheet secara default.
Menimpa: Jika Anda akan mengimpor data ke Spreadsheet Google yang ada, tulis formula di tab terpisah pada Spreadsheet Google untuk mempertahankan logika dalam formula. Jika Anda menggunakan fungsi penimpaan tindakan Google Spreadsheet, tindakan tersebut akan memperbarui Google Spreadsheet secara dinamis, dan data Anda akan secara otomatis dimuat ke tab pertama atau paling kiri di Google Spreadsheet. Jika ingin membuat spreadsheet baru beserta setiap pengiriman data agar Anda memiliki histori lengkap data dan dapat melacak perubahan dari waktu ke waktu, jangan gunakan fungsi penimpaan tindakan Google Spreadsheet.
Untuk mengirim atau menjadwalkan konten, ikuti langkah-langkah berikut:
Dari Penjadwal, di samping Ke mana data ini harus pergi?, pilih Google Spreadsheet sebagai tujuan pengiriman.
Jika mengirim ke Google Drive untuk pertama kalinya, Anda harus melakukan autentikasi dengan kredensial Google. Klik Login dengan Google, tentukan Akun Google Anda, lalu klik Izinkan untuk menghubungkan akun Looker ke kredensial Google OAuth. Anda hanya dapat menghubungkan satu set kredensial Google OAuth 2.0 ke integrasi ini.
Di Scheduler, klik Verifikasi kredensial untuk memuat Google Drive Anda.
Dari drop-down Pilih Drive untuk menyimpan file, pilih Google Drive tempat file CSV Anda akan disimpan.
Selanjutnya, Anda dapat memasukkan URL untuk folder di Drive ini atau mengambil semua folder di Drive Anda.
Di kolom Google Drive Destination URL, masukkan URL lengkap Google Drive dari folder tempat Anda ingin menyimpan data. Contoh: https://drive.google.com/corp/drive/folders/abcxyz. Jika URL ini tidak dapat diakses, data Anda akan disimpan ke folder root Google Drive Anda.
Dari drop-down Pilih Ambil untuk mengambil daftar folder di drive ini, pilih Ambil. Setelah dialog Penjadwal dimuat ulang, dari drop-down Pilih folder untuk menyimpan file, pilih folder Google Drive tempat file CSV Anda akan disimpan.
Tentukan nama file Google Spreadsheet di kolom Masukkan nama file. Anda tidak perlu menyertakan ekstensi file karena tindakan Google Spreadsheet akan otomatis menambahkannya selama pengiriman.
Di drop-down Timpa File yang Ada, pilih Ya atau Tidak. Memilih Tidak akan membuat Spreadsheet Google baru yang berisi ringkasan data Anda setiap kali pengiriman data. Memilih Ya akan memuat data Anda di tab pertama atau paling kiri pada Spreadsheet Google yang ada.
Karena batas sel Google Spreadsheet, jika Anda memilih opsi timpa, perlu diingat bahwa tab yang ditambahkan selama setiap pengiriman tidak dapat menyebabkan Spreadsheet melebihi batas 10 juta sel. Setelah batas sel terlampaui, jadwal berikutnya akan gagal.
Opsi lanjutan untuk CSV mencakup batas dan format yang dapat disesuaikan. Klik Kirim atau Jadwalkan.
Muat ulang folder Google Drive untuk melihat pengiriman file Anda.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-09-03 UTC."],[],[],null,["# Looker actions – Google Sheets\n\n| **Note:** You can also connect Google Sheets to Looker directly using the **Connected Sheets for Looker** feature. This feature lets users interactively explore data from LookML models through the familiar Google Sheets spreadsheet interface. Sheets users will have access to governed data from the databases that are supported by Looker. Exploration is intuitive since Connected Sheets presents an organized view of the model with views, fields, and measures just as they were defined in Looker. Looker data through Connected Sheets presents Looker data in standard Sheets constructs, such as pivot tables, charts, and formulas, allowing for flexibility of analysis through familiar constructs. For more information, see the [Using Connected Sheets for Looker](/looker/docs/connected-sheets) documentation page. For an overview of all the ways that Looker integrates with Google Sheets, see the [How Looker integrates with Google](/looker/docs/looker-google-integrations#google_sheets) documentation page.\n\u003e Customer-hosted instances may be unable to enable actions from the Looker Action Hub, especially actions that [support streamed results](/looker/docs/action-hub#uses_streaming) or that use [OAuth](/looker/docs/action-hub#configuring_an_action_for_oauth), if the customer-hosted Looker instance does not fulfill the [Looker Action Hub requirements](/looker/docs/action-hub#looker_action_hub_requirements).\n\u003e\n\u003e See the [Sharing data through an action hub](/looker/docs/action-hub#considerations_for_customer-hosted_instances) documentation page for suggested solutions to this potential issue.\n\n\nDoes your work require you to spend a lot of time in Google Sheets? You can use Looker's secure, OAuth-based action to send CSVs directly from Looker to Google Sheets on a one-off or recurring basis.\n\n\nThe Google Sheets action is integrated with Looker through the [Looker Action Hub](/looker/docs/admin-panel-platform-actions). Once the Looker admin has enabled the Google Sheets action in the Action Hub, users can select Google Sheets as a possible destination when sending or scheduling Looks or Explores.\n\n\nThis page walks admins through enabling the Google Sheets action in Looker. It also describes how any user who has the appropriate [permissions](/looker/docs/admin-panel-users-roles#permissions_list) can send or schedule deliveries in CSV format to a Google Sheet.\n| **Note:** If you have a permission that provides access to only select pages in the Admin panel, such as [`manage_schedules`](/looker/docs/admin-panel-users-roles#manage_schedules), [`manage_themes`](/looker/docs/admin-panel-users-roles#manage_themes), or [`see_admin`](/looker/docs/admin-panel-users-roles#see_admin), but you don't have the [Admin role](/looker/docs/admin-panel-users-roles#default_roles), the page or pages that are described here may not be visible to you in the Admin panel.\n\n\u003cbr /\u003e\n\nEnabling the Google Sheets action in Looker\n-------------------------------------------\n\nLooker admins can enable the Google Sheets action in Looker with the following steps:\n\n1. Go the **Admin** panel and, under **Platform** , go to the **Actions** page.\n2. On the list of Action Hub actions, scroll to Google Sheets and click the **Enable** button.\n3. On the **Google Sheets** action page, click the **Enabled** toggle to the on position, and click **Save**.\n4. When you return to the list of Action Hub actions, your Google Sheets action should be enabled.\n\n\nYou and your users --- if they have `send_to_integration` permissions --- can now send or schedule Looks or Explores in CSV format to a Google Sheet.\n\nDelivering data in CSV format to a Google Sheet\n-----------------------------------------------\n\n\nAny Looker user who has `send_to_integration` permissions can send or schedule Looks or Explores in CSV format to a Google Sheet.\n\u003e Google Sheets are [limited to 10 million cells](https://support.google.com/drive/answer/37603) for the entire Sheet. If your data table has columns, rows, or tabs that exceed this limit, any deliveries to the Google Sheet integration will fail.\n\nTo prepare your data before sending or scheduling it, follow these steps:\n\n- **Horizontal scaling:** If your data table contains more than 26 columns and you plan to import the data to an existing Google Sheet, you'll need to manually expand the Google Sheet before you can import your data into it.\n- **Vertical scaling:** If your data table contains more than 1,000 rows, Looker will add those rows to your Google Sheet by default.\n- **Overwriting:** If you're going to import your data into an existing Google Sheet, write any formulas on a separate tab of your Google Sheet to preserve the logic in your formulas. If you use the Google Sheets action's overwrite function, the action dynamically updates your Google Sheet, and your data will automatically be loaded into the first or leftmost tab of your Google Sheet. If you'd prefer to create a new spreadsheet with each data delivery so that you have a full history of your data and can track changes over time, don't use the Google Sheets action's overwrite function.\n\n\nTo send or schedule your content, follow these steps:\n\n1. From the [Scheduler](/looker/docs/delivering-looks-explores), next to **Where should this data go?** , select **Google Sheets** as your delivery destination.\n2. If you're delivering to Google Drive for the first time, you'll need to authenticate with your Google credentials. Click **Sign in with Google** , specify your Google Account, and then click **Allow** to connect your Looker account to your Google OAuth credentials. You can connect only one set of Google OAuth 2.0 credentials to this integration.\n3. In the Scheduler, click **Verify credentials** to load your Google Drive.\n4. From the **Select Drive to save file** drop-down, choose the Google Drive where your CSV file will be saved.\n\n Next, you can either enter the URL for a folder in this Drive or fetch all folders in your Drive.\n - In the **Google Drive Destination URL** field, enter the full Google Drive URL of the folder where you want to save your data. For example: `https://drive.google.com/corp/drive/folders/abcxyz`. If this URL isn't accessible, your data will be saved to the root folder of your Google Drive.\n - From the **Select Fetch to fetch a list of folders in this drive** drop-down, select **Fetch** . After the Scheduler dialog refreshes, from the **Select folder to save file** drop-down, select the Google Drive folder where your CSV file will be saved.\n5. Specify the name of your Google Sheet file in the **Enter a filename** field. You don't need to include the file extension --- the Google Sheets action will automatically append it during delivery.\n6. In the **Overwrite Existing Files** drop-down, select **Yes** or **No** . Selecting **No** will generate a new Google Sheet with a snapshot of your data with every data delivery. Selecting **Yes** will load your data in the first or leftmost tab of your existing Google Sheet.\n\u003e Because of [Google Sheets cell limits](https://support.google.com/drive/answer/37603), if you choose the overwrite option, keep in mind that the tabs that are added during each delivery cannot cause the Sheet to exceed the 10 million cell limit. Once the cell limit is exceeded, subsequent schedules will fail.\n7. Advanced options for CSVs include customizable [limit](/looker/docs/delivering-looks-explores#limit) and [format](/looker/docs/delivering-looks-explores#format_options). Click **Send** or **Schedule**.\n8. Refresh your Google Drive folder to see your file delivery.\n\nSwitching Google Accounts\n-------------------------\n\nTo associate a different Google Account with this action, you must delete the account's connection to the Looker instance. To learn more, see [Manage connections between your Google Account and third-parties](https://support.google.com/accounts/answer/13533235).\n\n\u003cbr /\u003e"]]
