You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: src/connections/destinations/catalog/actions-google-sheets/index.md
+5-10Lines changed: 5 additions & 10 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -2,17 +2,12 @@
2
2
title:Google Sheets Destination
3
3
hide-boilerplate:true
4
4
hide-dossier:false
5
-
hidden:true
6
-
private:true
7
5
id:627ea052118e3cd530d28963
8
6
---
9
7
10
-
The Google Sheets destination allows you to sync your warehouse data to a Google spreadsheet, andautomate updates to thatspreadsheet as your data changes. This destinationallows you to automate the workflow of exporting CSVs from your warehouse.
8
+
The Google Sheets destination allows you to sync your warehouse data to a Google spreadsheet, andupdate thespreadsheetautomaticallyas your data changes. This destinationautomates the workflow of exporting CSVs from your warehouse.
11
9
12
-
The Google Sheets destination is intended for use with**Reverse ETL sources only**.
13
-
14
-
>info ""
15
-
>The Google Sheets destination is in beta and is in active development. Some functionality may change before it becomes generally available.
10
+
The Google Sheets destination can be connected to**Reverse ETL warehouse sources only**.
16
11
17
12
##Getting started
18
13
@@ -26,13 +21,13 @@ The Google Sheets destination is intended for use with **Reverse ETL sources onl
26
21
3. Navigate to the**Reverse ETL > Destinations** tab and click**Add Destination**.
27
22
4. Select Google Sheets and click**Next**. Select the source you configured and name the destination.
28
23
5. On the**Settings** tab, authenticate the Google Sheets API using OAuth. Select the email account that owns the spreadsheet you created above. Make sure you enable the`See, edit, create, and delete all your Google Sheets spreadsheets` permission.
29
-
6. On the**Mappings** tab, click**Add Mapping** and create a Post Sheet mapping.Follow thesteps in the Destinations Actions documentation on[Customizing mappings](/docs/connections/destinations/actions/#customizing-mappings).
24
+
6. On the**Mappings** tab, click**Add Mapping** and create a Post Sheet mapping.Within themapping, configure how warehouse records should map to your Google Sheets spreadsheet.
30
25
7. Enable the destination and configured mappings.
31
26
32
27
>info ""
33
28
>The Google Sheets destination only supports sending new or updated rows to your spreadsheet. Deleting rows is not supported.
34
29
35
-
{% include components/actions-fields.html %}
30
+
{% include components/actions-fields.htmlsettings="false"%}
36
31
37
32
##FAQ
38
33
@@ -42,4 +37,4 @@ The Record Identifier mapping is used to make a distinction between adding a new
42
37
43
38
###How do I define the columns in my spreadsheet?
44
39
45
-
The Fields mapping controls which fields in your model will be written as columns. Input the desired column name(s) on the left, and select the data variable that will populate the value for that column on the right. Please note,at least oneField must be configured to send data to Google Sheets otherwise no columns will be created or synced.
40
+
The Fields mapping controls which fields in your model will be written as columns. Input the desired column name(s) on the left, and select the data variable that will populate the value for that column on the right. Please note,at least onefield must be configured to send data to Google Sheets otherwise no columns will be created or synced.