Fetch Google Spreadsheet Row Mapping

Generates mapping from a spreadsheet row.

Generates mapping from a spreadsheet to be used with a table mapping node like Map Table Rows To Any node to convert it into useful data to be used inside the automation. See an screenshare example at the bottom of the page.

Input Fields

field
schema
explanation
example
spreadsheet_id
google_drive_file_id
Select a spreadsheet from the dropdown.
-
range
table_range
Enter a range for one
Sheet1 or Sheet1!A1:Z

Output Fields

field
schema
explanation
example
mapping
table_row_mapping
see below
 

Example Usage

Example Dynamic Table Mapping Recipe
{"name":"Example Dynamic Table Mapping","description":"","nodes":{"start_1":{"type":"start","logging_enabled":false,"x":31,"y":319},"google_sheets_fetch_table_rows_v3_1":{"type":"google_sheets_fetch_table_rows_v3","logging_enabled":false,"x":232,"y":267,"inputs":{"spreadsheet_id":{"export_enabled":true,"data":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","context":{"mime_type":"application/vnd.google-apps.spreadsheet","ui":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","name":"Example - Automated Table Mapping","owners":[{"displayName":"Simon Kreienbaum","kind":"drive#user","me":true,"permissionId":"01137890803721275589","emailAddress":"simon@kitchn.io","photoLink":"https://lh3.googleusercontent.com/a-/ACB-R5TO3BdFJtiY3T4oSSOhf5M_YD3axFIif_9VxhYPOjcBL-WjOu-te-ck6n4uWy1tBd4n4O5_OQRbg_Ge5WmHcjLftLE3jtg8scyaxOuIBWDfkFm1zn3Z1b945dljP9sU7_1gKO7lKL9KblaLUdHP4nrpZoj66l7bW97PulVZMM57pXnz5LKJVs2BVrXo01TpmD-ZhjGKtMANO-rddbEwo4af1E959fjNsGVM_4OlbtrN1GgBCgGPUSv6Tj6C9TdO5R6NMBP0gqujh6UloZb6V-2gOdpwEUpoqFyeGaMicVqRy5cldscF3KTj7z4wacsqzUKwm201r-dcQ2WPd_AX9DqIjwHzVBKxn202XH4cwkQLU-zBpwyeGLVCfAUHrjaaEG9g1rzqq1YhX0TITKntLgZcIY5HA9xFA3Sltwt0eQIOCZm9A6QSvQLJrUJh-FiMQyD5RsD1RP5CwQN10gk9KPwG9khnenms70I5PgJPQlGUOGysTa8UKd27zX3bduLJOiWRrQtYJVL2nAdbjzCa9mHq4X1y9GNkPfk7fp-fdIqbZLPm4k1_l8Ooon96WY1HbSrksuNGAUJngfUMfg0831RPQmL75-RhPq4nIj-X5D7keD3-lxp4BFP8vPGr7pGDzXwapKRtcW-EQ5zUtUVBhRrObRlCsD2Dlbh1r1n9GO7g4DKXLSUEJ891PnKpUlqCzzPu9w1Nd0pYOIUT37QEKLbs3kpXdoxuEo_Q_4iUlo0M08juoqbelXDKdHp6_L71GLM4jxPg9PFHwHP1c7kZ1MkrkyHLMsPEkmvehcebU1DpisMR6xcN5CXOM8IHQKJqk3P7vogYhiqHiMn72TV_nAk1AtFOXc2i3YOwSkf2OILg-ZMrnwxrE-uIbtktWkSZlTC9zysWXq9mcqKaJ7c4BcsDK_MKDSYJfMiGcOqXLGWzlF1O9U6bvjSKTOg2=s64"}],"mime_type":"application/vnd.google-apps.spreadsheet"}},"provider":"google_drive","type":"file"}},"date_time_render_option":{"export_enabled":true,"data":"FORMATTED_STRING"},"value_render_option":{"export_enabled":true,"data":"UNFORMATTED_VALUE"},"dimension":{"export_enabled":true,"data":"ROWS"},"range":{"export_enabled":true,"data":"Sheet1!A4:Z"}}},"google_sheets_fetch_table_row_mapping_1":{"type":"google_sheets_fetch_table_row_mapping","logging_enabled":false,"x":542,"y":234,"inputs":{"range":{"export_enabled":true,"data":"Sheet1"},"spreadsheet_id":{"export_enabled":true,"data":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","context":{"mime_type":"application/vnd.google-apps.spreadsheet","ui":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","name":"Copy of Automated Table Mapping","owners":[{"displayName":"Simon Kreienbaum","kind":"drive#user","me":true,"permissionId":"01137890803721275589","emailAddress":"simon@kitchn.io","photoLink":"https://lh3.googleusercontent.com/a-/ACB-R5RyCXXdQR-uAF-Wh-FyIOL7v-ngdGhefbEk-R8t9cBPmrVR7tYD03dY2ZrnovKDd_nGahF9dYpyDwvqg0yDZRu1rma9dG4bQbgMjDGuLrjiMipzXuo7brkxepKorhqXKFfYhfT9jv-00SO50NyyeGkaTPxuXBka0SdHBavo5wOriTwX8EwkKaDOdd_BJCjae9eFtDVPgczAf2-kRiGBO4590PbJGQGuEFHiqQJUj9zWBJv9Aw33ZL0qO2k8mrhJe87Yk1VuQRK0Y_cpYSgnWchUFbZmxZt8ACOJUVOdhl-lWjNVPPbMdOD1KlH69n_lTPZMbZWxuNcMgv2IU-yjm0naBBW8sls9skdONf19kCGWGuP8zOZGjWhJYLRh6yk6nbpunHITVAhcOMVx6MXZkOPM5MnGsIjSGV8ByL4I4j2Xzs4SwTAnfVKC6d7XTpqnJg5M1qhjZq_aWVuFlzsOlsjvzQja5eyw6C-3Xj-eynLjeIBA4FnAthshv7N5PnWui2s4pNRKe8wd2keSoFG7xoUdWkUW5I2FtcndGpa0_Sp53awUgp64D6dVW7jvAHM3lHo-Ak-YpO51VgtJfBDKcid-XVq-UzG2cY38elIjwkK8AuE_H9r9WnifnLD1k3QLWBsGxcbkEaaOfoInZJqbc6UU5CxriE2_xecp7wMaPE2hcQ--7u4oISlRpbxOX9kUP0h0nYsBVSyjERs4hrdEMchzYGoTB19T_3PVG6TbmQamV9aZDG2tljux0pF-O92KLRQFC0ae97yncDkX0Ndipw-OmD6McMWaTtKubxS29lcQFzK8tQIzFYFf44peb4SCFKBRNvo3twCK2i7n8xf6ooh6xfUGppsNyTEw3ChD2VHgtrzlt65ZivbJ0JuUkOqiShGoUrkQbKcrCOu4iPXhdazX7if_C7mjhlbZ8U2mwYoJwLa3r2r67RH_Y9c8=s64"}],"mime_type":"application/vnd.google-apps.spreadsheet"}},"provider":"google_drive","type":"file"}}}},"map_table_rows_1":{"type":"map_table_rows","logging_enabled":false,"x":873,"y":367,"inputs":{"schema":{"export_enabled":true,"data":"any"}}},"patch_json_list_v2_1":{"type":"patch_json_list_v2","logging_enabled":false,"x":1189,"y":401,"inputs":{"patches":{"export_enabled":true,"data":[{"op":"remove","path":"/id/context"},{"op":"replace","path":"/data","value":{}},{"op":"add","path":"/data/checked","value":true}]},"value":{"export_enabled":true}}},"unmap_table_rows_1":{"type":"unmap_table_rows","logging_enabled":false,"x":1513,"y":393,"inputs":{"schema":{"export_enabled":true,"data":"any"}}},"google_sheets_update_table_rows_v2_1":{"type":"google_sheets_update_table_rows_v2","logging_enabled":false,"x":1826,"y":440,"inputs":{"spreadsheet_id":{"export_enabled":true,"data":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","context":{"mime_type":"application/vnd.google-apps.spreadsheet","ui":{"id":"18B4s4rLsn4JCLnfrDCeKhxglx5icSZNOLhFhPj62Z8c","name":"Example - Automated Table Mapping","owners":[{"displayName":"Simon Kreienbaum","kind":"drive#user","me":true,"permissionId":"01137890803721275589","emailAddress":"simon@kitchn.io","photoLink":"https://lh3.googleusercontent.com/a-/ACB-R5RolxMTie_aQg3nXNW4ugTNvrX0CtFP8kVdBcHX61eW7QJztczgBfCIS4283SbfIpbfAFxvLiac6gxV4qRLFGhUqjQ-Cp3PK9_nAQQI0D0Wpf8veAWjN62aqIH4sf9w9hWrb6kqb7HL6CK59mzX3GvE6XNZVjon72c3-8KwElh8DT8ivY7dp-NJlsAt4-B-FejjCsSGy47vX4CnzjuMh7xAI7Od5ppg9C_WU0axNZEe9fKYJ_q0KgxBlPczVfGQc2MECTExVMkQGPCxBCMBytzBLhOihriYcEew1N_x8O3L_VN-EgwruDrlKeUeGf3M2pbBLLPOgHDwDAqDjKF5k3l32ygj0mOMrw6UDoasYy4xMkh9_K_BEQPxY3ja6YzGu5AaKDs70GIscCAWhTqtawCAHKp9SpggIAJQo4-BmPQdC0X7-GDcd0mKZuDbnourqZU-tK9E4gXBw40vwskSQMkU6rTC0zUdmzJDTVpykj3N3l9iuSoANwbaeZP99hEuQd1Pv6tRzMn0D7_4LLlExhQfaXPMQG70N1Oemi-pzJm28dooMS-6RVc0siTnJw7iB4Vemj6oC8tQ6OH2TomfzUG3uJeSfPiP4ANjyUsnz1izQnZ090ri4RfnsZ2dxsSt7Q88jQpdg-da15GvXjtQkPwbJSvyTQuAzxD8jB3b7VaBkeU82-ID97zjWiCxpAos2JLs9PHco6p_FpA_og_gOCdyqO4zy7ISQNLcQKcGUvsoMh0rkLpyKxFCe97UQ6G-DZaWYRMeXmrvU3aejCot0_hYuGKqMUQ_awhyXAkhG877L9YGeePf3WzWU9i_pOZSGu2zKaiSbuZ80Ir3RbHCswjqMNcN8P_JaudJ6mcN2qY6PwshMYZu4gkkQS-a8dvizw5vp61ltm-D4Tp4lNQi6hU7olYCZaWoBkkBAszFQBXze7JWrnjYWljyacny=s64"}],"mime_type":"application/vnd.google-apps.spreadsheet"}},"provider":"google_drive","type":"file"}}}},"stop_1":{"type":"stop","logging_enabled":false,"x":2057,"y":728}},"edges":["google_sheets_fetch_table_rows_v3_1.rows:map_table_rows_1.rows","google_sheets_fetch_table_row_mapping_1.fetched:map_table_rows_1.map","unmap_table_rows_1.unmapped:google_sheets_update_table_rows_v2_1.update","google_sheets_fetch_table_rows_v3_1.fetched:google_sheets_fetch_table_row_mapping_1.fetch","patch_json_list_v2_1.data_list:unmap_table_rows_1.mapped_rows","unmap_table_rows_1.rows:google_sheets_update_table_rows_v2_1.rows","start_1.start:google_sheets_fetch_table_rows_v3_1.fetch","patch_json_list_v2_1.patched:unmap_table_rows_1.unmap","map_table_rows_1.mapped_rows:patch_json_list_v2_1.data_list","google_sheets_fetch_table_row_mapping_1.mapping:map_table_rows_1.mapping","map_table_rows_1.mapped:patch_json_list_v2_1.patch","google_sheets_fetch_table_row_mapping_1.mapping:unmap_table_rows_1.mapping","google_sheets_update_table_rows_v2_1.updated:stop_1.stop"],"groups":{},"widgets":{},"variables":{},"config":{"capture_inputs_enabled":false,"caching_enabled":false},"tags":[]}
 

In the example above, I used this spreadsheet.

Additionally if you are looking to send data back into the same sheet, check out this advanced tutorial.

Did this answer your question?
😞
😐
🤩

Last updated on February 28, 2023