# How to map Google Sheet data to HTTP Post request **URL:** \ **Category:** Questions\ **Tags:** http, google-sheets\ **Created:** [October 22, 2024, 9:05pm UTC](https://community.make.com/t/how-to-map-google-sheet-data-to-http-post-request/58576 "2024-10-22T21:05:32Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Wishmaster43](https://avatars.discourse-cdn.com/v4/letter/w/e99b99/32.png) [@Wishmaster43](https://community.make.com/u/Wishmaster43)\ **Post date:** [October 22, 2024, 9:05pm UTC](https://community.make.com/t/how-to-map-google-sheet-data-to-http-post-request/58576/1 "2024-10-22T21:05:32Z")
Hello I am trying to a simple HTTP post quest based on my google sheet values. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/b/4b34ca5e950be0ac2b9e7da70dfd3f06efb44510.png) But I cant map the value of the rows, what am I doing wrong? Can I also catch the response in a email action or Excel file? or update the row? ---
**Author:** ![makeitfuture](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/makeitfuture/32/6050_2.png) [@makeitfuture](https://community.make.com/u/makeitfuture)\ **Post date:** [October 22, 2024, 9:10pm UTC](https://community.make.com/t/how-to-map-google-sheet-data-to-http-post-request/58576/2 "2024-10-22T21:10:41Z")
Each row is a different bundle. You don’t need to use the map function. Just map the company You will get an http request for each row that the google sheet module will return. ---
**Author:** ![Wishmaster43](https://avatars.discourse-cdn.com/v4/letter/w/e99b99/32.png) [@Wishmaster43](https://community.make.com/u/Wishmaster43)\ **Post date:** [October 22, 2024, 9:21pm UTC](https://community.make.com/t/how-to-map-google-sheet-data-to-http-post-request/58576/3 "2024-10-22T21:21:50Z")
Thank for your fast reply however when I map it like this: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/3/f3d6e549d82364408ec18032fd9bd003df1201a5.png) And I run the HTTP the values aren’t pulling though: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/7/e7425641818f1b57c9033529079f0a022a106730.png) And when the call is finished nothing has passed or is created: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/9/e9611f3ba218b8ce952cc5e05b9981b24d584f1f.png) And I want to log the response: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/2/a2a6332b6ff17f61645127cbb81841c4ae0c7e10.png) So when it is 200 do this, when it is 400 then to this etc. But the first question is why is the mapping not working? ---
**Author:** ![Wishmaster43](https://avatars.discourse-cdn.com/v4/letter/w/e99b99/32.png) [@Wishmaster43](https://community.make.com/u/Wishmaster43)\ **Post date:** [October 23, 2024, 7:51am UTC](https://community.make.com/t/how-to-map-google-sheet-data-to-http-post-request/58576/4 "2024-10-23T07:51:19Z")
Anybody know why it is not working? ---
**Author:** ![Wishmaster43](https://avatars.discourse-cdn.com/v4/letter/w/e99b99/32.png) [@Wishmaster43](https://community.make.com/u/Wishmaster43)\ **Post date:** [October 23, 2024, 3:09pm UTC](https://community.make.com/t/how-to-map-google-sheet-data-to-http-post-request/58576/5 "2024-10-23T15:09:15Z")
![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/7/a73e565ae4d1a64fbdec530b9fcc235acd5014d5.png) I still dont het the right values, any idea? ---
**Author:** ![Wishmaster43](https://avatars.discourse-cdn.com/v4/letter/w/e99b99/32.png) [@Wishmaster43](https://community.make.com/u/Wishmaster43)\ **Post date:** [October 24, 2024, 12:35pm UTC](https://community.make.com/t/how-to-map-google-sheet-data-to-http-post-request/58576/6 "2024-10-24T12:35:47Z")
What I don’t understand is this: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/e/fe02d16ef460a6d0d8b837fd74d74c341d77c124.png) The fields are mapped correct but where is this 30 coming from? And when I run it everything is blank and nothing is created because only the 30 is passed. And after the HTTP call and I cleared the 30 I get this: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/2/2218c26da109bf38c69f54fcc9c82b7eb3137cb8.png) ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/e/beea27f9df86b704aadc43188ab1f8eeb5926ca8.png) Anybody an idea why this is happening? ---
**Author:** ![Donald\_Mitchell](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/donald_mitchell/32/8749_2.png) [@Donald\_Mitchell](https://community.make.com/u/Donald_Mitchell)\ **Post date:** [October 24, 2024, 5:00pm UTC](https://community.make.com/t/how-to-map-google-sheet-data-to-http-post-request/58576/7 "2024-10-24T17:00:01Z")
If you “Run this module only” on the HTTP module, you’re going to have to enter in each value that would otherwise get its value from a previous module. Google Sheets Watch New Rows is going to return 1 bundle for each row that is “new”. That means HTTP is going to run once for each bundle/row. When you look at the Watch New Rows output when mapping its output to another module, you’re only going to see an example (one row) of the data. When the scenario runs, it will run for each row of actual data. All you need to do is map the values from Google Sheets to HTTP like you did here: [![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/7/a73e565ae4d1a64fbdec530b9fcc235acd5014d5.png) ](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/7/a73e565ae4d1a64fbdec530b9fcc235acd5014d5.png) ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [November 7, 2024, 9:57pm UTC](https://community.make.com/t/how-to-map-google-sheet-data-to-http-post-request/58576/8 "2024-11-07T21:57:08Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.