/docs/community?hl=en
/docs/community?hl=en
7/21/12
Original Poster
jonf23

HTTP POST InfusionSoft webform into Google Spreadsheet?

Dear Community,

I am at my wits end.  Everything I received via search engine queries relevant to my question relates to a version of Google Spreadsheets with functionality that no longer exists.  I am not concerned about the InfusionSoft portion of my question.  I simply added it so that in the future if fellow InfusionSoft customers are asking the same question they may find the help they are looking for in this thread - I hope!  I appreciate all of those willing to help me work to resolution on this issue, it has consumed a large portion of my time and energy.  I am like unto Princesses Leah in the FIRST Star Wars - "Help me Google-Group-Users, you're my only Hope!"

InfusionSoft provides Instructions for their users to utilize the HTTP Post Function at the following URLs: InfusionSoft Users Guide Help Center  or How do I configure the HTTP Post object in a campaign sequence?

I was able to locate what I believe to be a detailed and somewhat accurate - if not dated - tutorial by Martin Hawksey on the POST function utilizing the Google Script Engine at Martin's site: Mashe.Hawksey.info - doGet/Post Method

I want to let everyone know that I am not a developer / programmer.  I am a hack, and I don't say that with pride.  I share this with you so that you can understand that I can look at the code on the Mashe page and not understand much of anything about what is going on.  I did have a buddy look at the code who is a programmer and he said that he believed that it was good to go to receive the POST.  

Here is the problem - I believe - I don't know which URL I should be providing to InfusionSoft.  This code references outdated terminology - Publish as Service - isn't an option.  What URL should I use and how do I get it? Also, what will that URL look like when it comes from InfusionSoft to Google?  It is my understanding that the field names from Infusionsoft will need to be appended in the URL, and I believe that InfusionSoft will do that for me automatically? What is the delimiter in an HTTP Post for each Column Header? is it a Dash? 

Also, for those with an expert eye, is there something else you would recommend or suggest that I modify / add? 

Again,  I want to thank all of you in advance for any help you can provide to me, and I am sure future searchers would like to thank you as well.

Regards,

JF
Community content may not be verified or up-to-date. Learn more.
All Replies (2)
7/21/12
Original Poster
jonf23
Ok - I feel like an idiot.  The Publish To ...  URL is to be found within the Google Script Engine NOT within the Spreadsheet.  That is how you get the URL that needs to be entered into InfusionSoft. 

Also, I altered the Code in the following manner:

/* var ss = SpreadsheetApp.openById(ScriptProperties.getProperty('active')); */
var ss = Logger.log(ScriptProperties.getProperty('active')); 

So now I have the InfusionSoft App communicating correctly with the Google Spreadsheet - I just need to get the Form to publish the data now.  
Google user
8/20/13
Google user
Jon - how has your integration with InfusionSoft and Google Spreadsheets been going?   I am intrigued by the possibility that you have spurred.....  
Were these replies helpful?
How can we improve them?
 
This question is locked and replying has been disabled. Still have questions? Ask the Help Community.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

 
Google Employee — Google product team members and community managers
 
Community Specialist — Google partners who help ensure the quality of community content
 
Platinum Product Expert — Community members with advanced product knowledge who help other Google users and Product Experts
 
Gold Product Expert — Community members with in-depth product knowledge who help other Google users by answering questions
 
Silver Product Expert — Community members with intermediate product knowledge who help other Google users by answering questions
 
Product Expert Alumni — Former Product Experts who are no longer members of the program
Community content may not be verified or up-to-date. Learn more.

Levels

Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:

  • Post an answer.
  • Having your answer selected as the best answer.
  • Having your post rated as helpful.
  • Vote up a post.
  • Correctly mark a topic or post as abuse.

Having a post marked and removed as abuse will slow a user's advance in levels.

View profile in forum?

To view this member's profile, you need to leave the current Help page.

Report abuse in forum?

This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.

Reply in forum?

This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.