Import integration

--- http_interactions: - request: method: get uri: https://spreadsheets.google.com/feeds/worksheets/ACCESS_TOKEN/private/full body: encoding: US-ASCII string: '' headers: Authorization: - Bearer CLIENT_ID Accept-Encoding: - gzip;q=1.0,deflate;q=0.6,identity;q=0.3 Accept: - '*/*' User-Agent: - Ruby response: status: code: 200 message: OK headers: Content-Type: - application/atom+xml; charset=UTF-8 X-Robots-Tag: - noindex, nofollow, nosnippet Expires: - Fri, 26 Sep 2014 09:28:02 GMT Date: - Fri, 26 Sep 2014 09:28:02 GMT Cache-Control: - private, max-age=0, must-revalidate, no-transform Vary: - Accept, X-GData-Authorization, GData-Version Gdata-Version: - '1.0' Last-Modified: - Fri, 26 Sep 2014 09:27:37 GMT Transfer-Encoding: - chunked Set-Cookie: - NID=67=MCC6HJ_TQsejcoAwitbsHKGmvWR3J4WG8R19Ofj5JX4REDm0eEi72xG0Ry6xa_vZs_GirhGfIPOXescOHy1MfDvW9XGhFktb8U0Fwt3eqejeTuCZ-rCCFpb8ADPSNfoM;Domain=.google.com;Path=/;Expires=Sat, 28-Mar-2015 09:28:02 GMT;HttpOnly P3p: - CP="This is not a P3P policy! See http://www.google.com/support/accounts/bin/answer.py?hl=en&answer=151657 for more info." X-Content-Type-Options: - nosniff X-Frame-Options: - SAMEORIGIN X-Xss-Protection: - 1; mode=block Server: - GSE Alternate-Protocol: - 443:quic,p=0.002 body: encoding: UTF-8 string: https://spreadsheets.google.com/feeds/worksheets/ACCESS_TOKEN/private/full2014-09-26T09:27:37.127ZImport integrationnm.dowsenm.dowse@gmail.com21https://spreadsheets.google.com/feeds/worksheets/ACCESS_TOKEN/private/full/od62014-09-26T09:27:37.127ZSheet1Sheet1261000https://spreadsheets.google.com/feeds/worksheets/ACCESS_TOKEN/private/full/o4zcp712014-09-26T09:27:37.127ZSheet2Sheet281000 http_version: recorded_at: Fri, 26 Sep 2014 09:28:02 GMT - request: method: get uri: https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full body: encoding: US-ASCII string: '' headers: Authorization: - Bearer CLIENT_ID Accept-Encoding: - gzip;q=1.0,deflate;q=0.6,identity;q=0.3 Accept: - '*/*' User-Agent: - Ruby response: status: code: 200 message: OK headers: Content-Type: - application/atom+xml; charset=UTF-8 X-Robots-Tag: - noindex, nofollow, nosnippet Expires: - Fri, 26 Sep 2014 09:28:02 GMT Date: - Fri, 26 Sep 2014 09:28:02 GMT Cache-Control: - private, max-age=0, must-revalidate, no-transform Vary: - Accept, X-GData-Authorization, GData-Version Gdata-Version: - '1.0' Last-Modified: - Fri, 26 Sep 2014 09:27:37 GMT Transfer-Encoding: - chunked Set-Cookie: - NID=67=g46YxwAFE6kmnhfEdcMctAzk3fVrT_DXS9B7ldy7CXWTaisNIi5oTt1_P2nDRsnTuu8C87T7mBXQAI_e_LnmvlMHklFnZr5U5EzCqQc4ru7RmrqsfsA-shgHyej4x1j1;Domain=.google.com;Path=/;Expires=Sat, 28-Mar-2015 09:28:02 GMT;HttpOnly P3p: - CP="This is not a P3P policy! See http://www.google.com/support/accounts/bin/answer.py?hl=en&answer=151657 for more info." X-Content-Type-Options: - nosniff X-Frame-Options: - SAMEORIGIN X-Xss-Protection: - 1; mode=block Server: - GSE Alternate-Protocol: - 443:quic,p=0.002 body: encoding: UTF-8 string: https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full2014-09-26T09:27:37.127ZSheet1nm.dowsenm.dowse@gmail.com1191100026https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C12014-09-26T09:27:37.127ZA1EmailEmailhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C22014-09-26T09:27:37.127ZB1NameNamehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C32014-09-26T09:27:37.127ZC1First NameFirst Namehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C42014-09-26T09:27:37.127ZD1Last nameLast namehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C52014-09-26T09:27:37.127ZE1StreetStreethttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C62014-09-26T09:27:37.127ZF1CityCityhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C72014-09-26T09:27:37.127ZG1StateStatehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C82014-09-26T09:27:37.127ZH1PostcodePostcodehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C92014-09-26T09:27:37.127ZI1Phone number Phone number https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C102014-09-26T09:27:37.127ZJ1Phone 2Phone 2https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C112014-09-26T09:27:37.127ZK1Phone 3Phone 3https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C122014-09-26T09:27:37.127ZL1Phone 4Phone 4https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C132014-09-26T09:27:37.127ZM1MotherMotherhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C142014-09-26T09:27:37.127ZN1PositionPositionhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C152014-09-26T09:27:37.127ZO1Phone (work)Phone (work)https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C162014-09-26T09:27:37.127ZP1DivisionDivisionhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R1C172014-09-26T09:27:37.127ZQ1CountryCountryhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C12014-09-26T09:27:37.127ZA2darrenp@fabrikam.comdarrenp@fabrikam.comhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C22014-09-26T09:27:37.127ZB2Darren ParkerDarren Parkerhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C32014-09-26T09:27:37.127ZC2DarrenDarrenhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C42014-09-26T09:27:37.127ZD2ParkerParkerhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C52014-09-26T09:27:37.127ZE21234 23rd Ave1234 23rd Avehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C62014-09-26T09:27:37.127ZF2GoldenGoldenhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C72014-09-26T09:27:37.127ZG2COCOhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C82014-09-26T09:27:37.127ZH28021580215https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C92014-09-26T09:27:37.127ZI2206-111-1234206-111-1234https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C102014-09-26T09:27:37.127ZJ2303-900-1234303-900-1234https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C112014-09-26T09:27:37.127ZK2555-1212555-1212https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C122014-09-26T09:27:37.127ZL2123-456-7890123-456-7890https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C132014-09-26T09:27:37.127ZM2FabrikamFabrikamhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C142014-09-26T09:27:37.127ZN2ManagerManagerhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C152014-09-26T09:27:37.127ZO2555-5555555-5555https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C162014-09-26T09:27:37.127ZP2ShippingShippinghttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R2C172014-09-26T09:27:37.127ZQ2USUShttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C12014-09-26T09:27:37.127ZA3tanjap@contoso.comtanjap@contoso.comhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C22014-09-26T09:27:37.127ZB3Tanja PlateTanja Platehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C32014-09-26T09:27:37.127ZC3TanjaTanjahttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C42014-09-26T09:27:37.127ZD3PlatePlatehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C52014-09-26T09:27:37.127ZE31234 Main St.1234 Main St.https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C62014-09-26T09:27:37.127ZF3SeattleSeattlehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C72014-09-26T09:27:37.127ZG3WAWAhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C82014-09-26T09:27:37.127ZH39801798017https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C92014-09-26T09:27:37.127ZI3206-555-0100206-555-0100https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C102014-09-26T09:27:37.127ZJ3206-555-0101206-555-0101https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C112014-09-26T09:27:37.127ZK3206-555-0102206-555-0102https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C122014-09-26T09:27:37.127ZL3206-555-1234206-555-1234https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C132014-09-26T09:27:37.127ZM3ContosoContosohttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C142014-09-26T09:27:37.127ZN3HR ManagerHR Managerhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C152014-09-26T09:27:37.127ZO3206-555-0104206-555-0104https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C162014-09-26T09:27:37.127ZP3ExecutiveExecutivehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R3C172014-09-26T09:27:37.127ZQ3USUShttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C12014-09-26T09:27:37.127ZA4allieb@tailspintoys.comallieb@tailspintoys.comhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C22014-09-26T09:27:37.127ZB4Allie BellewAllie Bellewhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C32014-09-26T09:27:37.127ZC4AllieAlliehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C42014-09-26T09:27:37.127ZD4BellewBellewhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C52014-09-26T09:27:37.127ZE44321 27th Ave NW4321 27th Ave NWhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C62014-09-26T09:27:37.127ZF4SeattleSeattlehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C72014-09-26T09:27:37.127ZG4WAWAhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C82014-09-26T09:27:37.127ZH49811798117https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C92014-09-26T09:27:37.127ZI4206-784-5690206-784-5690https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C102014-09-26T09:27:37.127ZJ4206-930-2946206-930-2946https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C112014-09-26T09:27:37.127ZK4555-1212555-1212https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C122014-09-26T09:27:37.127ZL4206-123-4567206-123-4567https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C132014-09-26T09:27:37.127ZM4TailspinToysTailspinToyshttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C142014-09-26T09:27:37.127ZN4HR RepHR Rephttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C152014-09-26T09:27:37.127ZO4555-5555555-5555https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C162014-09-26T09:27:37.127ZP4HRHRhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R4C172014-09-26T09:27:37.127ZQ4USUShttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C12014-09-26T09:27:37.127ZA5franzK@fabrikam.comfranzK@fabrikam.comhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C22014-09-26T09:27:37.127ZB5Franz KohlFranz Kohlhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C32014-09-26T09:27:37.127ZC5FranzFranzhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C42014-09-26T09:27:37.127ZD5KohlKohlhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C52014-09-26T09:27:37.127ZE51234 23rd Ave1234 23rd Avehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C62014-09-26T09:27:37.127ZF5GoldenGoldenhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C72014-09-26T09:27:37.127ZG5COCOhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C82014-09-26T09:27:37.127ZH58021580215https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C92014-09-26T09:27:37.127ZI5206-997-1234206-997-1234https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C102014-09-26T09:27:37.127ZJ5303-123-4659303-123-4659https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C112014-09-26T09:27:37.127ZK5555-1212555-1212https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C122014-09-26T09:27:37.127ZL5987-654-3210987-654-3210https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C132014-09-26T09:27:37.127ZM5FabrikamFabrikamhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C142014-09-26T09:27:37.127ZN5Program ManagerProgram Managerhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C152014-09-26T09:27:37.127ZO5555-5555555-5555https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C162014-09-26T09:27:37.127ZP5Program ManagementProgram Managementhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R5C172014-09-26T09:27:37.127ZQ5USUShttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C12014-09-26T09:27:37.127ZA6cindyw@fabrikam.comcindyw@fabrikam.comhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C22014-09-26T09:27:37.127ZB6Cindy WhiteCindy Whitehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C32014-09-26T09:27:37.127ZC6CindyCindyhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C42014-09-26T09:27:37.127ZD6WhiteWhitehttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C52014-09-26T09:27:37.127ZE64321 Main St.4321 Main St.https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C62014-09-26T09:27:37.127ZF6DenverDenverhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C72014-09-26T09:27:37.127ZG6COCOhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C82014-09-26T09:27:37.127ZH68023680236https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C92014-09-26T09:27:37.127ZI6123-987-6543123-987-6543https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C102014-09-26T09:27:37.127ZJ6303-900-1234303-900-1234https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C112014-09-26T09:27:37.127ZK6555-1212555-1212https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C122014-09-26T09:27:37.127ZL6123-987-6543123-987-6543https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C132014-09-26T09:27:37.127ZM6FabrikamFabrikamhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C142014-09-26T09:27:37.127ZN6WriterWriterhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C152014-09-26T09:27:37.127ZO6555-5555555-5555https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C162014-09-26T09:27:37.127ZP6UEUEhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R6C172014-09-26T09:27:37.127ZQ6USUShttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C12014-09-26T09:27:37.127ZA7chrisn@fabrikam.comchrisn@fabrikam.comhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C22014-09-26T09:27:37.127ZB7Chris NorredChris Norredhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C32014-09-26T09:27:37.127ZC7ChrisChrishttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C42014-09-26T09:27:37.127ZD7NorredNorredhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C52014-09-26T09:27:37.127ZE7PO Box 1234PO Box 1234https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C62014-09-26T09:27:37.127ZF7GreeleyGreeleyhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C72014-09-26T09:27:37.127ZG7COCOhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C82014-09-26T09:27:37.127ZH78011180111https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C92014-09-26T09:27:37.127ZI7303-901-2222303-901-2222https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C102014-09-26T09:27:37.127ZJ7303-801-2929303-801-2929https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C112014-09-26T09:27:37.127ZK7555-1212555-1212https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C122014-09-26T09:27:37.127ZL7123-987-6543123-987-6543https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C132014-09-26T09:27:37.127ZM7FabrikamFabrikamhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C142014-09-26T09:27:37.127ZN7Head EngineerHead Engineerhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C152014-09-26T09:27:37.127ZO7555-5555555-5555https://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C162014-09-26T09:27:37.127ZP7EngineeringEngineeringhttps://spreadsheets.google.com/feeds/cells/ACCESS_TOKEN/od6/private/full/R7C172014-09-26T09:27:37.127ZQ7USUS http_version: recorded_at: Fri, 26 Sep 2014 09:28:03 GMT recorded_with: VCR 2.9.2