/**
 * @OnlyCurrentDoc
 * @see https://developers.google.com/apps-script/guides/services/authorization
 *
 * @requires https://www.googleapis.com/auth/script.external_request
 */

function getJWTToken() {
  const url = 'https://time4realestate.com/wp-json/jwt-auth/v1/token';
  const payload = {
    username: 'kpstg',
    password: 'TLV%d7&GS3^cVW43^u(Ny!#&'
  };

  const options = {
    method: 'POST',
    contentType: 'application/json',
    payload: JSON.stringify(payload),
    muteHttpExceptions: true
  };

  const response = UrlFetchApp.fetch(url, options);
  const result = JSON.parse(response.getContentText());

  if (response.getResponseCode() === 200 && result.token) {
    return result.token;
  } else {
    throw new Error('Failed to get JWT token: ' + result.message);
  }
}

function createWordPressProperty(property) {
  const token = getJWTToken();
  
  const options = {
    method: 'POST',
    contentType: 'application/json',
    headers: {
      'Authorization': 'Bearer ' + token
    },
    payload: JSON.stringify({
      title: property.title,
      price: property.price,
      address: property.address,
      description: property.description,
      bedrooms: property.bedrooms,
      bathrooms: property.bathrooms,
      size: property.size,
      type: property.type,
      image_url: property.image_url
    }),
    muteHttpExceptions: true
  };

  const url = 'https://time4realestate.com/wp-json/realestate/v1/properties';

  const response = UrlFetchApp.fetch(url, options);
  const result = JSON.parse(response.getContentText());

  if (response.getResponseCode() !== 200 && response.getResponseCode() !== 201) {
    throw new Error('Failed to create property: ' + result.message);
  }
}

function updateWordPressProperty(property) {
  const token = getJWTToken();
  
  const options = {
    method: 'POST',
    contentType: 'application/json',
    headers: {
      'Authorization': 'Bearer ' + token
    },
    payload: JSON.stringify({
      title: property.title,
      price: property.price,
      address: property.address,
      description: property.description,
      bedrooms: property.bedrooms,
      bathrooms: property.bathrooms,
      size: property.size,
      type: property.type,
      image_url: property.image_url
    }),
    muteHttpExceptions: true
  };

  const url = 'https://time4realestate.com/wp-json/realestate/v1/properties/' + property.ID;

  const response = UrlFetchApp.fetch(url, options);
  const result = JSON.parse(response.getContentText());

  if (response.getResponseCode() !== 200 && response.getResponseCode() !== 201) {
    throw new Error('Failed to update property: ' + result.message);
  }
}

function onEdit(e) {
  if (e && e.range) {
    const editedRow = e.range.getRow();
    const sheet = e.source.getActiveSheet();
    const dataRange = sheet.getDataRange();
    const values = dataRange.getValues();

    if (editedRow > 1 && editedRow <= values.length) {
      const property = {
        ID: values[editedRow - 1][0] !== '' ? values[editedRow - 1][0] : null,
        title: values[editedRow - 1][1],
        price: values[editedRow - 1][2] !== '' ? values[editedRow - 1][2] : null,
        address: values[editedRow - 1][3] !== '' ? values[editedRow - 1][3] : null,
        description: values[editedRow - 1][4] !== '' ? values[editedRow - 1][4] : null,
        bedrooms: values[editedRow - 1][5] !== '' ? values[editedRow - 1][5] : null,
        bathrooms: values[editedRow - 1][6] !== '' ? values[editedRow - 1][6] : null,
        size: values[editedRow - 1][7] !== '' ? values[editedRow - 1][7] : null,
        type: values[editedRow - 1][8] !== '' ? values[editedRow - 1][8] : null,
        image_url: values[editedRow - 1][9] !== '' ? values[editedRow - 1][9] : null
      };

      if (!property.ID) {
        try {
          createWordPressProperty(property);
          Logger.log('New property created successfully.');
        } catch (error) {
          Logger.log('Failed to create new property: ' + error);
        }
      } else {
        try {
          updateWordPressProperty(property);
          Logger.log('Property updated successfully.');
        } catch (error) {
          Logger.log('Failed to update property: ' + error);
        }
      }
    }
  } else {
    console.log("Event object or range is undefined.");
  }
}

const WORDPRESS_API_URL = 'https://time4realestate.com/wp-json/realestate/v1/properties';

function fetchPropertiesFromWordPress() {
  const response = UrlFetchApp.fetch(WORDPRESS_API_URL);
  const properties = JSON.parse(response.getContentText());
  
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clear();
  
  const headers = ['ID', 'Title', 'Price', 'Address', 'Description', 'Bedrooms', 'Bathrooms', 'Size', 'Type', 'Image URL'];
  sheet.appendRow(headers);
  
  properties.forEach(property => {
    sheet.appendRow([
      property.ID, 
      property.title, 
      property.price, 
      property.address, 
      property.description, 
      property.bedrooms,
      property.bathrooms,
      property.size,
      property.type,
      property.image_url
    ]);
  });
}

function onOpen() {
  const ui = SpreadsheetApp.getUi();
  ui.createMenu('WordPress')
    .addItem('Fetch Properties', 'fetchPropertiesFromWordPress')
    .addToUi();
}
<?xml version="1.0"?>
<oembed><version>1.0</version><provider_name>Time 4 Real Estate</provider_name><provider_url>https://time4realestate.com</provider_url><author_name>kpstg</author_name><author_url>https://time4realestate.com/author/kpstg/</author_url><title>New Pre-construction Sales</title><type>rich</type><width>600</width><height>338</height><html>&lt;blockquote class="wp-embedded-content" data-secret="shIUqnI4As"&gt;&lt;a href="https://time4realestate.com/preconstruction/"&gt;New Pre-construction Sales&lt;/a&gt;&lt;/blockquote&gt;&lt;iframe sandbox="allow-scripts" security="restricted" src="https://time4realestate.com/preconstruction/embed/#?secret=shIUqnI4As" width="600" height="338" title="&#x201C;New Pre-construction Sales&#x201D; &#x2014; Time 4 Real Estate" data-secret="shIUqnI4As" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"&gt;&lt;/iframe&gt;&lt;script type="text/javascript"&gt;
/* &lt;![CDATA[ */
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&amp;&amp;d.addEventListener&amp;&amp;"undefined"!=typeof URL&amp;&amp;(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&amp;&amp;!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i&lt;o.length;i++)o[i].style.display="none";for(i=0;i&lt;a.length;i++)s=a[i],e.source===s.contentWindow&amp;&amp;(s.removeAttribute("style"),"height"===t.message?(1e3&lt;(r=parseInt(t.value,10))?r=1e3:~~r&lt;200&amp;&amp;(r=200),s.height=r):"link"===t.message&amp;&amp;(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&amp;&amp;n.host===r.host&amp;&amp;l.activeElement===s&amp;&amp;(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r&lt;s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
/* ]]&gt; */
&lt;/script&gt;
</html></oembed>