Yang Anda perlukan untuk menghubungkan Google Sheets ke Heyflow adalah Akun Google. Jika Anda belum memilikinya, siapkan akun Google di sini – gratis
Catatan. Setiap alur dapat diintegrasikan dengan satu lembar Google – dengan kata lain, Anda tidak dapat mengintegrasikan alur yang sama dengan beberapa Lembar Google
Berikut adalah cara mengintegrasikan Google Sheets
Buka halaman Integrasi dan pilih penangan respons Google Sheets
gs4_create( "sheet-copy-demo-aaa", sheets = list(mtcars = head(mtcars), chickwts = head(chickwts)) ) #> ✔ Creating new Sheet: sheet-copy-demo-aaa. # copy 'mtcars' sheet within existing Sheet, accept autogenerated name ss_aaa %>% sheet_copy() #> ✔ Duplicating sheet mtcars in sheet-copy-demo-aaa. #> ✔ Copied as Copy of mtcars. # copy 'mtcars' sheet within existing Sheet # specify new sheet's name and location ss_aaa %>% sheet_copy(to_sheet = "mtcars-the-sequel", .after = 1) #> ✔ Duplicating sheet Copy of mtcars in sheet-copy-demo-aaa. #> ✔ Copied as mtcars-the-sequel. # make a second Sheet ss_bbb <- gs4_create("sheet-copy-demo-bbb") #> ✔ Creating new Sheet: sheet-copy-demo-bbb. # copy 'chickwts' sheet from first Sheet to second # accept auto-generated name and default location ss_aaa %>% sheet_copy("chickwts", to_ss = ss_bbb) #> ✔ Copying sheet chickwts from sheet-copy-demo-aaa to sheet-copy-demo-bbb. #> ✔ Copied as Copy of chickwts. # copy 'chickwts' sheet from first Sheet to second, # WITH a specific name and into a specific location ss_aaa %>% sheet_copy( "chickwts", to_ss = ss_bbb, to_sheet = "chicks-two", .before = 1 ) #> ✔ Copying sheet chickwts from sheet-copy-demo-aaa to sheet-copy-demo-bbb. #> ✔ Copied as chicks-two. # clean up gs4_find("sheet-copy-demo") %>% googledrive::drive_trash() #> Files trashed: #> • sheet-copy-demo-bbb #> • sheet-copy-demo-aaa 0. Merujuk ke lembar yang ada berdasarkan nama (melalui string) atau berdasarkan posisi (melalui nomor). Jika tidak ditentukan, Spreadsheet menempatkan sheet baru di bagian akhir