Dengan tugas Spreadsheet - Tambahkan, Anda dapat menambahkan data setelah tabel data tertentu dalam spreadsheet Google. Nilai baru ditambahkan ke baris baru yang dibuat setelah tabel yang ditentukan, dimulai dengan kolom pertama tabel.
Google Spreadsheet adalah salah satu dari banyak solusi produktivitas berbasis cloud di Google Workspace. Aplikasi ini memungkinkan Anda membuat dan mengedit spreadsheet online dengan fungsi kolaborasi real-time.
Sebelum memulai
Pastikan Anda melakukan tugas berikut di project Google Cloud sebelum mengonfigurasi tugas Spreadsheet - Tambahkan:
Aktifkan Google Sheets API (sheets.googleapis.com).
Halaman Integrasi akan muncul dan mencantumkan semua integrasi yang tersedia di project Google Cloud.
Pilih integrasi yang ada atau klik Buat integrasi untuk membuat integrasi baru.
Jika Anda membuat integrasi baru:
Masukkan nama dan deskripsi di panel Buat Integrasi.
Pilih region untuk integrasi.
Pilih akun layanan untuk integrasi. Anda dapat mengubah atau memperbarui detail akun layanan integrasi kapan saja dari panel infoRingkasan integrasi di toolbar integrasi.
Klik Buat. Integrasi yang baru dibuat akan terbuka di editor integrasi.
Di menu navigasi editor integrasi, klik Tugas untuk melihat daftar tugas dan konektor yang tersedia.
Klik dan tempatkan elemen Sheets - Tambahkan di editor integrasi.
Klik elemen Sheets - Append di perancang untuk melihat panel konfigurasi tugas Sheets - Append.
Buka Authentication, lalu pilih profil autentikasi yang ada yang ingin Anda gunakan.
Opsional. Jika Anda belum membuat profil autentikasi sebelum mengonfigurasi tugas, klik + Profil autentikasi baru dan ikuti langkah-langkah seperti yang disebutkan dalam Membuat profil autentikasi baru.
Buka Input Tugas, lalu konfigurasi kolom input yang ditampilkan menggunakan tabel Parameter input tugas berikut.
Perubahan pada kolom input akan disimpan secara otomatis.
Parameter input tugas
Tabel berikut menjelaskan parameter input tugas Sheets - Append:
Properti
Jenis data
Deskripsi
SpreadsheetId
String
ID spreadsheet Anda.
Anda dapat menemukan ID spreadsheet dari URL web-nya. Contoh, https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit#gid=0
Rentang
String
Notasi A1 dari rentang untuk menelusuri tabel yang diinginkan di sheet.
IncludeValuesInResponse
Boolean
Menunjukkan apakah objek yang ditampilkan harus menyertakan nilai sel yang ditambahkan nilai.
Strategi penanganan error untuk tugas menentukan tindakan yang harus dilakukan jika tugas gagal karena error sementara. Untuk mengetahui informasi tentang cara menggunakan strategi penanganan error, dan untuk mengetahui berbagai jenis strategi penanganan error, lihat Strategi penanganan error.
Kuota dan batas
Untuk mengetahui informasi tentang kuota dan batas, lihat Kuota dan batas.
[[["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."],[[["\u003cp\u003eThe \u003cstrong\u003eSheets - Append\u003c/strong\u003e task in Application Integration allows users to add new data after a specified table within a Google spreadsheet.\u003c/p\u003e\n"],["\u003cp\u003eBefore using the \u003cstrong\u003eSheets - Append\u003c/strong\u003e task, users must enable the Google Sheets API and create an authentication profile in their Google Cloud project.\u003c/p\u003e\n"],["\u003cp\u003eThe task requires several input parameters, such as SpreadsheetId, Range, and various options that dictate how the new data is handled and formatted.\u003c/p\u003e\n"],["\u003cp\u003eThe output of the \u003cstrong\u003eSheets - Append\u003c/strong\u003e task provides details about the appended data, including the spreadsheet ID, updated range, and the number of updated rows, columns, and cells.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003cstrong\u003eSheets - Append\u003c/strong\u003e task is currently in a Pre-GA offering stage, which means it's available "as is" with potentially limited support and is subject to specific service terms.\u003c/p\u003e\n"]]],[],null,["# Sheets - Append task\n\nSee the [supported connectors](/integration-connectors/docs/connector-reference-overview) for Application Integration.\n\nSheets - Append task\n====================\n\n|\n| **Preview**\n|\n|\n| This feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n\n\nThe **Sheets - Append** task lets you append data after a specified table of data in a Google spreadsheet. New values are appended to the new row that is created after the specified table, starting with the first column of the table.\n| **Spreadsheet:** The primary object in Google Sheets that can contain multiple sheets. Each [sheet](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/sheets) has structured information contained in [cells](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/cells).\n|\n| You can find the ID of your spreadsheet from its web URL. For example, `https://docs.google.com/spreadsheets/d/`\u003cvar translate=\"no\"\u003eSPREADSHEET_ID\u003c/var\u003e`/edit#gid=0`\n\n\n[Google Sheets](https://developers.google.com/sheets) is one of the many cloud-based productivity solutions in [Google Workspace](/workspace). It allows you to create and edit online spreadsheets with real-time collaboration functionality.\n\nBefore you begin\n----------------\n\nEnsure that you perform the following tasks in your Google Cloud project before configuring the **Sheets - Append** task:\n\n1. Enable the Google Sheets API (`sheets.googleapis.com`).\n\n\n [Enable the Google Sheets API](https://console.cloud.google.com/flows/enableapi?apiid=sheets.googleapis.com)\n2. Create an [authentication profile](/application-integration/docs/configuring-auth-profile#createAuthProfile). Application Integration uses an authentication profile to connect to an authentication endpoint for the **Sheets - Append** task.\n\n For information about granting additional roles or permissions to a service account, see [Granting, changing, and revoking access](/iam/docs/granting-changing-revoking-access).\n3. Understand and learn about the [common terminologies](https://developers.google.com/sheets/api/guides/concepts) used in Google Sheet.\n\nConfigure the Sheets - Append task\n----------------------------------\n\n1. In the Google Cloud console, go to the **Application Integration** page.\n\n [Go to Application Integration](https://console.cloud.google.com/integrations)\n2. In the navigation menu, click **Integrations** .\n\n\n The **Integrations** page appears listing all the integrations available in the Google Cloud project.\n3. Select an existing integration or click **Create integration** to create a new one.\n\n\n If you are creating a new integration:\n 1. Enter a name and description in the **Create Integration** pane.\n 2. Select a region for the integration. **Note:** The **Regions** dropdown only lists the regions provisioned in your Google Cloud project. To provision a new region, click **Enable Region** . See [Enable new region](/application-integration/docs/enable-new-region) for more information.\n 3. Select a service account for the integration. You can change or update the service account details of an integration any time from the info **Integration summary** pane in the integration toolbar. **Note:** The option to select a service account is displayed only if you have enabled integration governance for the selected region.\n 4. Click **Create** . The newly created integration opens in the *integration editor*.\n\n\n4. In the *integration editor* navigation bar, click **Tasks** to view the list of available tasks and connectors.\n5. Click and place the **Sheets - Append** element in the integration editor.\n6. Click the **Sheets - Append** element on the designer to view the **Sheets - Append** task configuration pane.\n7. Go to **Authentication** , and select an existing authentication profile that you want to use.\n\n Optional. If you have not created an authentication profile prior to configuring the task, Click **+ New authentication profile** and follow the steps as mentioned in [Create a new authentication profile](/application-integration/docs/configuring-auth-profile#createAuthProfile).\n8. Go to **Task Input** , and configure the displayed inputs fields using the following [Task input parameters](#params) table.\n\n Changes to the inputs fields are saved automatically.\n\nTask input parameters\n---------------------\n\n\nThe following table describes the input parameters of the **Sheets - Append** task:\n\nTask output\n-----------\n\nThe **Sheets - Append** task returns the response output containing a [AppendValuesResponse](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append#body.response_body) object, similar to the following sample output: \n\n```json\n {\n \"spreadsheetId\": SPREADSHEET_ID,\n \"tableRange\": \"Sheet1!A1:D2\",\n \"updates\": {\n \"spreadsheetId\": SPREADSHEET_ID,\n \"updatedRange\": \"Sheet1!A3:D4\",\n \"updatedRows\": 2,\n \"updatedColumns\": 4,\n \"updatedCells\": 8,\n }\n }\n```\n\nError handling strategy\n-----------------------\n\n\nAn error handling strategy for a task specifies the action to take if the task fails due to a [temporary error](/application-integration/docs/error-handling). For information about how to use an error handling strategy, and to know about the different types of error handling strategies, see [Error handling strategies](/application-integration/docs/error-handling-strategy).\n\nQuotas and limits\n-----------------\n\nFor information about quotas and limits, see [Quotas and limits](/application-integration/docs/quotas).\n\nWhat's next\n-----------\n\n- Add [edges and edge conditions](/application-integration/docs/edge-overview).\n- [Test and publish](/application-integration/docs/test-publish-integrations) your integration.\n- Configure a [trigger](/application-integration/docs/how-to-guides#configure-triggers).\n- Add a [Data Mapping task](/application-integration/docs/data-mapping-task).\n- See [all tasks for Google Cloud services](/application-integration/docs/how-to#configure-tasks-for-google-cloud-services)."]]
