#Materi Video

(will be updated later)

#Materi Teks

Untuk dapat mengakses google sheet menggunakan API ada 2 cara yaitu lewat Oauth atau Service Account. Kita akan gunakan yg kedua yaitu Service Account karena lebih mudah cara pembuatannya.

Pertama buka https://console.cloud.google.com

https://s3.ap-southeast-1.amazonaws.com/kelas-kodingworks/uploads/4b9f1897-2087-4573-b95b-5c8d378335dc/bb656194-769d-412b-aba6-46301a87b936/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARTIUHKW6EI6RW4XR%2F20240707%2Fap-southeast-1%2Fs3%2Faws4_request&X-Amz-Date=20240707T132247Z&X-Amz-Expires=3000&X-Amz-Signature=1accb20a95f068207edb959aac4e4a724cf2d2312fb3123d19b648a4ca22e91c&X-Amz-SignedHeaders=host&response-content-disposition=attachment

Klik kotak Select a project ya

https://s3.ap-southeast-1.amazonaws.com/kelas-kodingworks/uploads/4b9f1897-2087-4573-b95b-5c8d378335dc/32957e6a-7973-4b03-8030-b0b6f0c071c9/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARTIUHKW6EI6RW4XR%2F20240707%2Fap-southeast-1%2Fs3%2Faws4_request&X-Amz-Date=20240707T132247Z&X-Amz-Expires=3000&X-Amz-Signature=9345d4d3b967e38e1d76f81cbb3914b3bb8835346a4c98172636c49448a4ba3a&X-Amz-SignedHeaders=host&response-content-disposition=attachment

Bisa pilih project yg ada atau bikin baru, bebas pilih mana, saya pilih project yg sudah ada aja, dibuat kemarin ketika membuat API Key Gemini

https://s3.ap-southeast-1.amazonaws.com/kelas-kodingworks/uploads/4b9f1897-2087-4573-b95b-5c8d378335dc/7a9c8dba-76d9-43ad-b571-77ffe18d1228/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARTIUHKW6EI6RW4XR%2F20240707%2Fap-southeast-1%2Fs3%2Faws4_request&X-Amz-Date=20240707T132247Z&X-Amz-Expires=3000&X-Amz-Signature=0d091ea28f83a3211bb4669f6a61ed289e3b0c2d154c1c04111846c7267b4f59&X-Amz-SignedHeaders=host&response-content-disposition=attachment

Pada icon strip 3 sebelah icon Google Cloud, diklik ya, lalu pilih APIs & Service, dan pilih Credentials

https://s3.ap-southeast-1.amazonaws.com/kelas-kodingworks/uploads/4b9f1897-2087-4573-b95b-5c8d378335dc/8ba8947e-b789-4cf7-9f7d-a3cfe1a7205c/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARTIUHKW6EI6RW4XR%2F20240707%2Fap-southeast-1%2Fs3%2Faws4_request&X-Amz-Date=20240707T132247Z&X-Amz-Expires=3000&X-Amz-Signature=d1a1a0f52df8702d629c0a52bd5dc748b31ef7ad57826d409bb699eb7e30ee10&X-Amz-SignedHeaders=host&response-content-disposition=attachment

Lalu klik tombol Create Credentials

https://s3.ap-southeast-1.amazonaws.com/kelas-kodingworks/uploads/4b9f1897-2087-4573-b95b-5c8d378335dc/44f170bb-00ed-48c3-ab6c-da5f86fe8e01/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARTIUHKW6EI6RW4XR%2F20240707%2Fap-southeast-1%2Fs3%2Faws4_request&X-Amz-Date=20240707T132247Z&X-Amz-Expires=3000&X-Amz-Signature=a1262624fd34170d242a748353bc2eb3784d80620f7bdc950228af676efff6e0&X-Amz-SignedHeaders=host&response-content-disposition=attachment

Pilih Service Account

https://s3.ap-southeast-1.amazonaws.com/kelas-kodingworks/uploads/4b9f1897-2087-4573-b95b-5c8d378335dc/b789ad41-21ae-4b97-8a98-cfdeb08c2af6/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARTIUHKW6EI6RW4XR%2F20240707%2Fap-southeast-1%2Fs3%2Faws4_request&X-Amz-Date=20240707T132247Z&X-Amz-Expires=3000&X-Amz-Signature=11904c967ef5178a637a0aca22e7c972355ad3e605a21ea486c57a12ab298138&X-Amz-SignedHeaders=host&response-content-disposition=attachment

Beri nama service account, diisi bebas, saya isi wabot, lalu klik tombol Create and continue

https://s3.ap-southeast-1.amazonaws.com/kelas-kodingworks/uploads/4b9f1897-2087-4573-b95b-5c8d378335dc/c63f5726-fa12-4e0a-8c40-025f5c1f8a69/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARTIUHKW6EI6RW4XR%2F20240707%2Fap-southeast-1%2Fs3%2Faws4_request&X-Amz-Date=20240707T132247Z&X-Amz-Expires=3000&X-Amz-Signature=6becd488b791b6e3d035594806415d7631b079d7084633cb59a49f46349538d5&X-Amz-SignedHeaders=host&response-content-disposition=attachment

Lalu klik done

https://s3.ap-southeast-1.amazonaws.com/kelas-kodingworks/uploads/4b9f1897-2087-4573-b95b-5c8d378335dc/73d310db-0559-4b00-8e60-e125361c75c8/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARTIUHKW6EI6RW4XR%2F20240707%2Fap-southeast-1%2Fs3%2Faws4_request&X-Amz-Date=20240707T132247Z&X-Amz-Expires=3000&X-Amz-Signature=b7da25c97e1cac68499b1dd387dcd33e80d19d3a787c70dd8003bae9049db058&X-Amz-SignedHeaders=host&response-content-disposition=attachment